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