I have a column of 10 values in cells B1 TO B10 :
(These change constantly and can be up to 25 values)
Shell
BP
Castrol
Jute
Baldwin
Mian
BT
Esso
Costa
Starbucks
I am now going through values in Column C (1500 values):
If a C value equals any of the B values in the list it will be shaded,
I'm missing a little something in the code below, many thanks
For i = 1500 to 1 Step -1
If Cells(i,3) = ....
Then cells(i,3).interior.colorindex = 33
End If
Next
Bookmarks