Conditional Formatting

[Betty Csehi]

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.

 

[Maistrye]

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

 

[Guest]

I just did a test and it seems to want:
Cell value
is equal to
="Yes"

 

[Gord Dibben]

Let Excel change it to ="Yes"

You just type plain old Yes in the dialog box with no quotes.

Excel will handle it from there.

If you type "Yes" then you will wind up with =""Yes""


Gord Dibben MS Excel MVP