Compare Two Sheets and Highlight Differences

[Blake 7]

Hi Guys,

I have been given a task at work which I am having trouble coming up with a suitable solution for and wondered if someone may have done this before or could recommend a VBA approach.

I am trying to compare two sheets within the same workbook (Sheet1 = New and Sheet2 = Old)

Both sheets contain user records in col A

I don't want to change anything in the New Sheet, but I want to compare the user records with the old records and if there are any updates, deletions/modifications between the records, I want to highlight them in yellow on the New sheet. It might also be good to extract any records which have changed to another Sheet so I can identify how many records have changed. Does this sound possible?

I have attached a workbook to demonstrate the data.

Any help would be welcomed. Many thanks for looking