| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Can I fill colour in a excel cell from a return from an "IF" test.
I have entered an "if" statement in excel to return true or false . Can I
additionally change the cell fill colour automatically based on the Returned value eg True - blue or False - red |
|
#2
|
|||
|
|||
|
Using conditional formatting you can.
Look up 'Highlight cells that meet specific conditions' in the Answer wizard in help -- HTH RP (remove nothere from the email address if mailing direct) "williamw" wrote in message ... I have entered an "if" statement in excel to return true or false . Can I additionally change the cell fill colour automatically based on the Returned value eg True - blue or False - red |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I reference every "n" cell in a column in Excel? | Excel Worksheet Functions | |||
| How Can I make a cell flash in Excel | Excel Discussion (Misc queries) | |||
| Formula to return cell contents based on multiple conditions | Excel Worksheet Functions | |||
| I have typed in an excel cell and cannot advance to next cell by . | Excel Discussion (Misc queries) | |||
| Changing Cell Fill Colour | Excel Discussion (Misc queries) | |||
Linear Mode
