Maybe your formula isn't returning a logical TRUE/FALSE.

Try this:
FormatConditional Formatting
Condition 1:
Cell Formula is: ="true"

Condition 2:
Cell Formula is: ="false"

Does that fix it?

Regards,
Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=492161