I know this is a relatively simple macro, and surely this has been answered before but I cannot locate it. But, Schedule Compare Tool.xlsmI'm struggling and now wasting more time then making progress.

In a nut shell, I have two sheets that need comparing (Old to Current). It first needs to find the exact match in Column A (ID). Then compare all the follow on data (Columns B-F) for that Unique ID & highlight the differences on sheet 1 (Current). If no match to Unique ID is found in either sheet, it should highlight that ID a different color.

Please help! THANK YOU SO VERY MUCH!