Click on the cell, hit "Conditional Formatting" and "New Rule," go to "Format
only cells that contain," enter Specific Text: "Yes", set the format to Blue
text, and hit ok. To see what the rule is, hit conditional formatting again
and "Manage rules" where you'll see what the formatting applies to.

"gibbylinks" wrote:

I've looked at conditional formatting. I used to be able to fly this under
the old versions, but (sorry should have said) I'm using Office 2007 and I
can't see how to apply it to jus tone cell !!

Very confusing

"Rob Wills" wrote:

Hi

Have a look at Conditional formatting

HTH
Rob
===================

"gibbylinks" wrote:

I have a drop down box with YES/NO. I want to turn the text to RED if "Yes"
is selected and Blue if "No" is selected.

How do I apply it to the one cell ?

Thanks