Comparing two sheets and highlight unmatched data

Hi Team,

I am here for another help. I have two sheets named new and master. I want to check the employee data are perfect in the newly added data (i.e. New tab).

In New sheet there are 4 columns namely, Employee #, name, Address and Phone Number.

In Master Sheet there are 4 columns namely, Employee Number, Name, Address and Employee Phone # in both the sheets. (there is a difference in the headings)

First, it has to check whether the employee in new tab is available in master tab. If not it has to be highlighted in Red.

Second, it has to check whether the name has been updated correctly in the new sheet comparing to master sheet. If not it has to be highlighted in Red.

Third, it has to check whether the Address has been updated correctly in the new sheet comparing to master sheet. If not it has to be highlighted in Red.

Fourth, it has to check whether the Phone Number has been updated correctly in the new sheet comparing to master sheet. If not it has to be highlighted in Red.

Please note, there can be format changes and there could be spaces in a cell after the string. Macro has to ignore these format and spaces.

Your help on this would be really appreciated.


Thanks,
Vignesh

Hi Patel,

Sure, I have attached a sample file.

Here all that i am looking is, new sheet has to match with the master sheet. If not, it has to highlight in Blue and the matching data has to highlight in Yellow. Could you please help me with this.

Your help would be really appreciated!


Thanks,
Vignesh

Hi Patel,

Any luck on this? Please advice...


Thanks,
Vignesh