Comparing two worksheets and highlight unmatched Data

Oct 22, 2012
Reaction score
Hi Team,

I have did a search for what i am looking for but I haven't got what i am exactly seeking. I am sure, here the experts can help me with this.

I have two worksheets named New and Old respectively and the datas would look like as shown in the attachment.

In the attached workbook, New sheet needs to compare with old sheet and the columns that needs to refer are Employee Number, Name and Date of Birth.

If employee # is not matching then mark the entire row in Red since Employee # can be the Key to search in old sheet (Example employee # 789).

The thing here is, if any data that is not matching for a particular employee, then that cell has to be highlighted in Red and the matching data in Green.

Please advice if this can be done.

Your help will be really appreciated.



    7 KB · Views: 64

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question