Macro based on Primary key

Hi,


I have data in sheet1 and sheet2.It will comparesheet1 data with sheet2 data based on empid.If empid matches
with sheet2 then chcek all the data for the empid whether it is matching or not.If any column values is mismatching for that particular id in sheet1 and sheet2
then highlight those unmatched columns with red background in both the sheets.If empid not present in any sheet then highlight that entire record with red color background color.Output Highlighted in bold color below.Sheet1 and sheet2 have more number of columns not only 4 columns .but sheet1 and sheet2 have same number of columns.

sheet1

Empid name loc age
1 a d 23
2 b e 21
3 c f 20
4 d g 22
5 e h 24
6 f i 25

sheet2
Empid name loc age
1 a d 23
2 b e 21
3 c f 20
4 f g 22
5 e k 24
7 f j 26