Hi Mandeep,

As you say you are limited to 3 conditional formats but you also have
the default format so you may be able to achieve what you want.

If you want just a coloured cell you have two options. One is to
format the cell purely on the result of another cell or you can set the
font colour within the cell to be the same as the cell colour.

HTH

Ed


--
EdMac
------------------------------------------------------------------------
EdMac's Profile: http://www.excelforum.com/member.php...o&userid=30736
View this thread: http://www.excelforum.com/showthread...hreadid=522556