You can do this with Conditional Formatting. Select your range of cells.
Go to Format. Select Conditional Format. You can then enter the
conditions under which a cell would turn which color.
--
jonhunt
------------------------------------------------------------------------
jonhunt's Profile:
http://www.excelforum.com/member.php...o&userid=35370
View this thread:
http://www.excelforum.com/showthread...hreadid=570812