Hi all. I would like to create a macro that will do the following, the input is any spreadsheets A & B:
- If cell is populated in A and not in B, highlight cell in A with red.
- If cell is populated in B and not in A, highlight cell in B with red.
- If a cell mismatches in A and B, highlight the cell in A & B with Yellow.
I was thinking of searching active rows and comparing them using the InStr() function...but I wonder if there is a quicker way.