Can i Custom Format so the word Apple will show [Red]?

Custom Format:
[='Apple'][Red]

Sorry Lenze, that formula makes "all" words show as Red.

Hi Tony,

Try, format>conditional formatting> condition 1
cell value is = to: apple> format>patterns> click
on red > add
Next
Condition 2,
cell value is not equal to apple>format>patterns>
click on black > add

hope this helps,

Jim

Hi Jim,
Unfortunately, i have already used all of my Conditional Formating allowances for my cells. I will "have to" use Custom Formatting

Tony

Hi Tony, Try, format>conditional formatting> condition 1

Hi Tony,

I remember seeing something along these lines posted
a while back, and it you can accomplish what your
trying to do with vba code. If you don't get anymore
repsonces scroll down and you will probably find
your answer.

Good luck,

Jim

Tony, you can paste this code in to your worksheet (make whatever changes you require).

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
Dim Position As Long

Position = InStr(Target.Value, "apple")
If Position = 0 Then Exit Sub
With Target.Characters(Start:=Position, Length:=5).Font
.ColorIndex = 3
End With
End Sub

Regards,
BarrieBarrie Davidson

Minor correction to posting above

Tony, use this instead (the first one was case sensitive).

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
Dim Position As Long
Dim SearchString As String

SearchString = LCase(Target.Value)
Position = InStr(SearchString, "apple")
If Position = 0 Then Exit Sub
With Target.Characters(Start:=Position, Length:=5).Font
.ColorIndex = 3
End With
End Sub

Regards,
BarrieBarrie Davidson