Conditional formatting (FormatConditional Formatting).

Choose the expression and value you want, and select a colour from the
pattern tab.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"excel formula" <excel wrote in message
...
How do I change a cell color if another cell = a certain value?


Also, does anyone know of an excel formula book?