The most you can do is four colours.
You can use the three conditional formatting rules PLUS you can colour
the cell. If none of the conditions are met then the default
colour/format will apply.


--
flydecoder
------------------------------------------------------------------------
flydecoder's Profile: http://www.excelforum.com/member.php...o&userid=27288
View this thread: http://www.excelforum.com/showthread...hreadid=467800