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?