conditional format

[Julian Campbell]

I can colour cells with conditional format with basic yes/no for example.
But how do I enter say 4 or 5 variants into a conditional format

Thanks

 

[Frank Kabel]

Hi
see your other post

 

[Gord Dibben]

Julian

Use VBA or see John MCGimpsey's site for instructions on getting 6 CF for a
cell.

Note: John's work-around is for numerics only.

Looks like you want CF for text, so VBA would be the way to go.

Sample worksheet event code.............

Option Compare Text
Private Sub Worksheet_Change(ByVal Target As Range)
Dim Num As Long
Dim rng As Range
Dim vRngInput As Variant
Set vRngInput = Intersect(Target, Range("A:A"))
If vRngInput Is Nothing Then Exit Sub
On Error GoTo endit
Application.EnableEvents = False
For Each rng In vRngInput
'Determine the color
Select Case rng.Value
Case Is = "A": Num = 10 'green
Case Is = "B": Num = 1 'black
Case Is = "C": Num = 5 'blue
Case Is = "D": Num = 7 'magenta
Case Is = "E": Num = 46 'orange
Case Is = "F": Num = 3 'red
End Select
'Apply the color
rng.Interior.ColorIndex = Num
Next rng
endit:
Application.EnableEvents = True
End Sub


Gord Dibben Excel MVP