Home |
Search |
Today's Posts |
#1
|
|||
|
|||
IF statements if the value is True it changes the cell colour?
Is there a way to change the colour of the cell when using an IF statement.
ie: I would like to see the cell Green if it is TRUE and Red if it is FALSE |
#2
|
|||
|
|||
No need for if statements,
=A1 as opposed to =IF(A11 look up conditional formatting in help -- Regards, Peo Sjoblom (No private emails please) "J. Kerr" <J. wrote in message ... Is there a way to change the colour of the cell when using an IF statement. ie: I would like to see the cell Green if it is TRUE and Red if it is FALSE |
#3
|
|||
|
|||
use <format<conditional format formula is your if statement format green
use your if statement with a NOT in front with format red "J. Kerr" wrote: Is there a way to change the colour of the cell when using an IF statement. ie: I would like to see the cell Green if it is TRUE and Red if it is FALSE |
#4
|
|||
|
|||
The easiest way is to use Conditional Formatting
Conditional Formatting http://www.mvps.org/dmcritchie/excel/condfmt.htm The formula used in Conditional Formatting is a worksheet formula and you want to think in terms of selecting an entire column rather than an individual cell at a time. select column C1 then column C, just so you have C1 as the active cell format, conditional formatting formula is: =C120 is going to be True (used) or False (ignored) errors are ignored format button, use patterns then chose color for interior --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "J. Kerr" <J. wrote in message ... Is there a way to change the colour of the cell when using an IF statement. ie: I would like to see the cell Green if it is TRUE and Red if it is FALSE |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
True to TRUE | Excel Discussion (Misc queries) | |||
Nested IF statements | Excel Worksheet Functions | |||
Adding True False Results | Excel Worksheet Functions | |||
Grand Totals @ Same Place | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |