#1
|
|||
|
|||
Conditional formatting of cell, Excel 2003
How to make the cell look different bases on the result of the formula?
There is something in the help for 2003 about it, but that is truly incomprehensible! For instance, I would like to get the cell to have green background if result is TRUE and red one if result is FALSE. If not the background, the font colour will do. |
#2
|
|||
|
|||
Incomprehensible?
Simply use Format - Conditional formating and set what you want |
#3
|
||||
|
||||
In order to get the conditional formatting to work you have to first select the data you wish to format and then choose the conditional formatting button. From the second list choose "Equals to" and type for an example TRUE. From the "Format" button choose the color of your liking. To get the tool to color the "FALSE" cells in a different color, choose the conditional formatting again and do the same procedure all over except next to "Equals to" type FALSE.
Hope this helps. Rgrds, Kristiina |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excel 2003 formatting issue when moving to new WB | aramsey | Excel | 2 | 04-22-2010 02:34 PM |
Challenge!! Need help though. (Conditional formatting) | knuckles70 | Excel | 2 | 02-05-2010 12:24 PM |
Conditional Text Adding - Word 2003 | chuck | Mail Merge | 0 | 06-17-2009 08:09 AM |
Cell formatting | Niko | Excel | 5 | 04-23-2009 12:05 AM |
Conditional Formatting to Hide Rows or Columns? | sczegus | Excel | 0 | 09-26-2006 04:17 PM |