I just tested using xl2007.
Right click sheet tabview codecopy/paste the macro. It will work for col
E.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"dcb1" wrote in message
...
I tried what you gave me; however, I wasn't successful (I was
uncertain on the first part where you said right click sheet tabview
code?) I have excel 2007 if that makes any difference. Anyhow, I
appreciate you taking the time to help me. I was able to use the
other solutions given. Thanks again. Also, I have another problem I
am trying to figure out. I will post it--- maybe you can help me.

On Aug 17, 9:26 am, "Don Guillett" wrote:
If you don't want a lot of CF then right click sheet tabview codeinsert
this. Set to col E now.

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column < 5 Or Target.Count < 1 Then Exit Sub
Select Case LCase(Target)
Case "x": mc = 3
Case "y": mc = 5
Case Else
mc = 0
End Select
'Application.EnableEvents = False
Target.Font.ColorIndex = mc
'Application.EnableEvents = True
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"dcb1" wrote in message

...



When I select the letter 'X' from a drop down list, I want it to
display it in red automatically. However, I don't want to have to
change the font color. Therefore, each time I enter this character---
the font will be shown in red. Anything else I choose from this list
will display in black (which of course is the default). Is there a
way to do this? Or, even if it is not from a drop down list, when I
enter a particular character in a cell--- I want it to show that
particular character in a specific color.- Hide quoted text -

- Show quoted text -