IF statements if the value is True it changes the cell colour?

[Guest]

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

 

[Peo Sjoblom]

No need for if statements,

=A>1

as opposed to =IF(A1>1

look up conditional formatting in help

--
Regards,

Peo Sjoblom

(No private emails please)

 

[Guest]

use <format><conditional format> formula is your if statement format green
use your if statement with a NOT in front with format red

 

[David McRitchie]

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: =C1>20 is going to be True (used) or False (ignored) errors are ignored
format button, use patterns then chose color for interior