Betty Csehi Wrote:
I have text (Yes and No) in various cells. If the cell contains a Yes,
I
want the color to be Blue.

I've gone into conditional formatting and selected:
Cell Value is
Equal to
Yes
(and then formatted to blue text)

When I do this, I get no change. Can someone help??

Thanks.

When you go back into the conditional formatting after you've entered
it, the formula should look like this:

="Yes"

If it has double double quotes (like ""Yes""), it won't work.

Scott


--
Maistrye
------------------------------------------------------------------------
Maistrye's Profile: http://www.excelforum.com/member.php...o&userid=36078
View this thread: http://www.excelforum.com/showthread...hreadid=562485