Hi all,
I am a complete novice with macros and VBA
I have a list of words in column G, and sometimes two words or phrases with a comma. I am trying to highlight on each line in column E, any data which is relating to the cell in column G
For example, Cell G2 has 0
I want 0 to be highlighted in cell E2 in red
If cell G3 says: service,delivery I want cell E3 to have the words service and delivery highlighted in red.
I am trying this:
Sub HL()
Dim r As Range, l As Long
For Each r In Range("E2", Range("E99999").End(xlUp))
l = InStr(1, r.Value, r.Offset(0, -6).Value, 1)
If l Then r.Characters(Start:=l, Length:=Len(r.Offset(0, -6).Value)).Font.Color = vbRed
Next
End Sub
Can somerone please help? My spreadsheet is attached
Bookmarks