How to compare two sheets with unique Id in the table and highlight the differences in each sheet by cell

[Mohit Madan]

Compare two sheets in an Excel workbook and highlight the differences in each sheet by cell .. sheets are not sorted but unique Id is present in both the sheets.. any new row to be highlighted and placed in another sheer

 

[vletm]

Mohit Madan
Procedure would be same as to do above manually...
Name 'one sheet' as 'master'
1) find 'unique id' and its related data
2) find from 'other sheet' same 'unique id'
3) compare 'master's related data with 'other sheet's related data
3a) if differences then 'highlite'
3b) if missing then do needed as You need
4) repeat steps 1 to 3 as many times as needs
> Please, reread Forum Rules - How to get the Best Results at Chandoo.org --- eg a sample file