Compare two lists and highlight differences.

I have two lists with identical columns. I have named them Master List and Second List. I need to compare Master List to Second List, row by row and column by column and highlight the entire row in Master List if any of the data in that row does not identically match what is in Second List. Then do the same with comparing Second List with Master List. I have a attached a sample of what I am trying to accomplish. I have tried CF and code from other threads but can't seem to get it right.

You would need to concatenate all those items in each of those lists...

Selecting First List from Row 3 onwards:


Conditional format for First List:

Please Login or Register  to view this content.

and reverse for Second List.