below is the conditional formatting recorded

for String:= I need it to read a string variable. I need it to reference a two digit country code that has been looked up from another sheet.

after, i want to highlight a certain range like A1 to N1

then i want it to do do this for all of Column N.

can i modify this code a bit or do I need to start from scratch.

    
Columns("N:N").Select
    Selection.FormatConditions.Add Type:=xlTextString, String:="PH", _
        TextOperator:=xlContains
    Selection.FormatConditions(Selection.FormatConditions.Count).SetFirstPriority
    With Selection.FormatConditions(1).Interior
        .PatternColorIndex = xlAutomatic
        .ColorIndex = xlAutomatic
    End With
    Selection.FormatConditions(1).StopIfTrue = False
any and all help would be much appreciated.