Conditional Formatting

[Dummy Excel]

Hi All,
I am using xl07 and have tried to record a macro to select column A and then if it finds a match for BE highlight it in one colour, if it finds a match for HO then highlight in a different colour (I have 4 selections in total) although all it records is selecting column A. Firstly why is that and secondly can someone help me out with some code?

thanks

 

[asking]

Just have to change the themeColor and TintAndShade lines for the
colours you want.

This was a straight forward recorded macro

Sub ShadeMe()
    Columns("A:A").Select
    Selection.FormatConditions.Add Type:=xlTextString, String:="BE", _
        TextOperator:=xlContains
    Selection.FormatConditions(Selection.FormatConditions.Count).SetFirstPriority
    With Selection.FormatConditions(1).Interior
        .PatternColorIndex = xlAutomatic
        .ThemeColor = xlThemeColorAccent1
        .TintAndShade = 0.399945066682943
    End With
    Selection.FormatConditions(1).StopIfTrue = False
    Selection.FormatConditions.Add Type:=xlTextString, String:="HO", _
        TextOperator:=xlContains
    Selection.FormatConditions(Selection.FormatConditions.Count).SetFirstPriority
    With Selection.FormatConditions(1).Interior
        .PatternColorIndex = xlAutomatic
        .ThemeColor = xlThemeColorAccent6
        .TintAndShade = 0.599963377788629
    End With
    Selection.FormatConditions(1).StopIfTrue = False
    Range("A1").Select
End Sub

 

[Dummy Excel]

thanks that works perfectly