Conditional Format Text - Yes/No

[gibbylinks]

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

 

[Rob Wills]

Hi

Have a look at Conditional formatting

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

 

[Rob Wills]

or alternatively place the following in the vba for that sheet

Private Sub Worksheet_Change(ByVal Target As Range)
If Range("E7").Value = "Yes" Then
Range("E7").Font.Color = vbRed
ElseIf Range("E7").Value = "No" Then
Range("E7").Font.Color = vbBlue
End If
End Sub

 

[gibbylinks]

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

 

[Babymech]

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.