I have a file with 2 columns that are around 7000 cells long and contain mostly the same information. I want to make the cells on one column that do not exist on the other column yellow. Also, these sheets are on separate sheets so I think I have to use a sheet variable(?).
The one I want to have cells that turn yellow is column F on sheet 4 and the one I want to compare it with is sheet 3 row E. I made and uploaded a test file with with the exact sheets/row. So with this file I need a macro that will turn the cells that aren't on the column on the third sheet E but are on the fourth sheet F turn yellow.
I would greatly appreciate any type of help. Thank you.
Bookmarks