Hi,
I have 2 ranges - Range 1(Sheet1 A1:A30) and Range 2(Sheet 2 B1:B600)
I want to search each value from Range 1 and find it in Range 2. If the value is found in Range 2 I want to select that cell and put a border around it. Any suggestions would be greatly appreciated.
Below is what I am trying but cant seem to get to it to work.
Thanks in advance!Please Login or Register to view this content.
Bookmarks