Once you put in the conditions, click on format and you can select the
color. Then you can set a second or third condition and select
different colors for different variables.


--
jonhunt
------------------------------------------------------------------------
jonhunt's Profile: http://www.excelforum.com/member.php...o&userid=35370
View this thread: http://www.excelforum.com/showthread...hreadid=570812