Hi guys,

Hope i can get some input on this. the scenarios is this:

sheet 1 column b
sheet 2 column a

for each row in sheet 2 col B compare with each row sheet1 col A. IF
row equal, then change color for the equal row in sheet 2 col A.

Thnx