I use a commercial Add-in from Jim Cone called XLCompanion for this. It
works super.............saved my bacon on several occasions.

Vaya con Dios,
Chuck, CABGx3



"Jim" wrote:

Is there a way to have Excel compare two worksheets and highlight the
differences (cell by cell) between the two worksheets?