Need Macro to Compare Two Sheets with Same Columns Highlight Differences using Unique ID

Hi,

I don't think you need a macro to do this... if I understand what you want you should be able to do this with 2 conditional formatting statements and a few vlookup & match functions.

Take a look at the attached and see if this is what you're looking for...

Best regards,
Mike