You can use CF

See
http://www.contextures.com/xlCondFormat01.html


--
Regards Ron de Bruin
http://www.rondebruin.nl


"ajyourpal" wrote in message ...
How can I set up my worksheet so that the color of the cell will change based
on the value in that cell? For example, if the numeric value is 7, the color
of the cell will be red.

Any suggestions?