Loop and lookup
Posted on 2012-03-27
I have made an attempt at a sub that looks through Column A of a pivot and then attempts to match it to a pivot on another tab, if the value is there the selection turns green, if not, it turns red. My syntax or method is wrong however!
Can anyone offer suggestions?
Do Until ActiveCell = "Grand Total"
If(VLOOKUP(selection,'Phoenix Pivot'!A:A,1,0) = true then
Selection.Interior.Color = 65280
Selection.Interior.Color = 255