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