How do you automatically change the color of a cell based on the value?

conditional format,
in the search bar in your forum type in conditional format, you will
get numerous explainations for this


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=519943

Check out conditional formatting in help.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Cliff N." <Cliff wrote in message
...
How do you automatically change the color of a cell based on the value?

or a web page
http://www.mvps.org/dmcritchie/excel/condfmt.htm