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

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

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" 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

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

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