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