Question about Microsoft Office Professional 2007 Full Version for PC

1 Answer

Conditional Formatting doesn't work until I select the item

OK, So I've got a report where each row contains a date. I want to be able to format the report so that if the status field is 'B' then it has red background, if its 'A' then has a green background, otherwise leave it as it is.

I've selected the conditional formatting option, and added the rules.

When I run the report, all the rows come out without the formatting *UNTIL* I click on the textbox with my data in, when the formatting appears.

Any ideas on how to get it to display the formatting all the time?

Access 2007 SP1

Posted by on

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that gotĀ 5 achievements.

    Governor:

    An expert whose answer gotĀ voted for 20 times.

    New Friend:

    An expert that has 1 follower.

  • Expert
  • 109 Answers

The mouser is equip with shortcut of any of program by using right click pointing to item.

Posted on Oct 18, 2008

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

2 Answers

How do I set up excel to change the background of a cell as the information within the call changes?


Conditional formating should be able to this. But how is your data organized? (Column headers, Row headers etc.)

Oct 20, 2014 | Microsoft Excel for PC

2 Answers

IS THERE A FORMULA IN EXCEL THAT WILL HIGHLIGHT CELLS THAT MATCH A NUMERICAL INVENTORY LIST?


One way would be to create a colunn C and use the formula: =COUNTIF(B$2:B$200,A2) in cell C2. Then copy the formula down to C200. (assuming you have 200 entries in B...). This will put a "1" next to every number in Column A that has a match in column B. Then you could put a conditional formula in column A that will highlight the cell if the value in column C is equal to 1. Alternatively you could also simply filter for 1's in column C and then manually highlight the cells that show up in A!

Sep 16, 2014 | Microsoft Excel for PC

1 Answer

Excel Conditional Formatting: how do I make one cell highlight based on whether or not another cell is blank?


option: formula is
formula: =(datecell="")
select formatting of choice

Highlight the order cells, go to >format>conditional formatting, choose "formula is" instead of "cell is". When you refer to the datecell, use the first date cell in the column only, and do not use $ signs.

Jan 09, 2013 | Microsoft Excel Business & Productivity...

1 Answer

Excel 2007: Conditional formatting


did you put the sheet name in your reference? ex =Sheet2!A1 or you can name the cell ranges on the other sheets and use the cell names in your conditional formatting formla.

May 08, 2009 | Microsoft Excel for PC

1 Answer

Conditional formating to highlight problems.


in Excel 2007 and if you have a cell (say C2) with the value of elapsed time (for example set = A2 which contains start time plus B2 which contains end time - or current time) - click in the cell (C2) then on the Home tab click on Styles >> Conditional formatting choose Highlight Cells Rules>>Greater Than... set your value in the dialog to your respective value and choose your highlight. This is a start - you can then add new rules.

to then apply this same conditional formatting to every cell in that column Ctrl-C to copy the cell you just formatted - then click on the column header to highlght the entire column - Right-click and choose Paste Special - then choose Formatting for what to paste.

It's slightly different in Excel 2003 so let us know what version you are using.

Cheers.

Feb 27, 2009 | Microsoft Office Standard for PC

1 Answer

I have a year planner in excel in which first row consist of month jan,feb.... and in the second row days are there like 1, 2,3..... and on the very first column name of employees is there so my task is to...


There is always multiple solutions, but here is one...

Add a row (that can be hidden later if you want) where you have the full date (01/01/09). For this example it will be row "C." Then use Conditional Formatting with the function:

=weekday(C$2,2)>5.

See if this helps.

Jan 03, 2009 | Microsoft Excel for PC

1 Answer

Highlight weekend in the year planner


The easiest way of doing this is by inserting another row with Days
Can be MTWT etc, and you can set conditional formatting for any cell beginning with "S" into a colour/ variation of your choice.

Jan 03, 2009 | Microsoft Excel for PC

1 Answer

To highligh weekend in the year planner


The easiest way of doing this is by inserting another row with Days
Can be MTWT etc, and you can set conditional formatting for any cell beginning with "S" into a colour/ variation of your choice.

Jan 03, 2009 | Microsoft Excel for PC

1 Answer

Conditional formatting


http://chandoo.org/wp/2008/03/13/want-to-be-an-excel-conditional-formatting-rock-star-read-this/

Go down to the section about highlighting where there's an error. That's the basics of what you want to do. Now you need the code:

This will set a value of "True" if the string is -not- found inside. So if you want to flag it for finding the word NOT, you want the conditional formatting to kick in if the value of this is FALSE.
=iserr(find("NOT",A1))

Dec 06, 2008 | Business & Productivity Software

1 Answer

Deleting rows with odd row numbers in one go


Hi,
I have found ASAP-Utilities to be excellent for this.

http://www.asap-utilities.com

After you download (free) and install, then in the ASAP menu, go to Columns/Rows, and select the first item ("Conditional Row and Column, select, hide or delete"). The options are clear.



Thanks
Proton

Sep 13, 2008 | Microsoft Business & Productivity Software

Not finding what you are looking for?
Microsoft Office Professional 2007 Full Version for PC Logo

Related Topics:

60 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18298 Answers

Tony

Level 3 Expert

2598 Answers

Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...