Conditional formatting to highlight differences between two worksheets
Posted on 2013-06-16
I have been driving myself crazy trying to find the answer to this problem.
I have two contact lists, each in their own worksheet in an Excel 2010 workbook.
I need to find if any contact names in contact list B match those in contact list A. And if the name matches I need to check if the rest of their details are the same. If they dont match, I would like to use conditional formatting to highlight the cells that are different in contact list A.
I then also need to do the opposite, compare list A to B and highlight the unique contact names.
I spent a large part of yesterday trying to figure this out with no success. What I think I just figured out this morning was that using the VLOOKUP formula to return the matching text from the other worksheet, the conditional format doesn't seem to be able to recognise when the text matches and hence format the cell appropriately.
I would really appreciate any assistance that anyone may have. My brain turned to mush yesterday. Thanks.