Sheet Comparison

[stangz71]

I need to write a macro that compares Sheet1 and Sheet2 on a workbook, comparing all columns from each sheet. If there is a difference in Sheet2, highlight the corresponding cell on Sheet1. This will allow me to know if a mistake was made on Sheet2 quickly and make the necessary adjustments. Any help would be appreciated.

[stangz71]

Let me know if the request above makes sense, thanks.

[stangz71]

I found a macro that does part of what I need but encounters an error. Since there are so many talented scripters on this forum, I am sure someone could figure it out, thanks.