there is no built in support for it. You would have to check the underlying
condition.

You can also look at Chip Pearson's page on this topic:

http://www.cpearson.com/excel/CFColors.htm

--
Regards,
Tom Ogilvy



"hme" wrote:


Thanks a lot.

Yes thats right.That is conditional formatting.

How can I use IF function with that? For example :

IF Conditional format is equal to 1 or 2 ' return something ' otherwise
'return something else'

thk

hme


--
hme
------------------------------------------------------------------------
hme's Profile: http://www.excelforum.com/member.php...o&userid=15930
View this thread: http://www.excelforum.com/showthread...hreadid=537999