Hi,
I have a list on range for sheet2.range("A1:A1000"). If any cell value
in sheet1 matches the value in my original list in Sheet2, I want to
highlight the cell.offset(0,-1) and cell.offset(0,-2). I got lost in
the for each code:) Is there someone can guide me through with a
code? I rephrase my problem for clarification. I basically want to
highlight the left two cells if any cell in sheet1 matches my list in
sheet2.Thank you very much for your help.
Have a nice day
Baha