Hi,

Is it possible to easily check all cells on Sheet2 are exactly the
same as on Sheet1? Note, I then have to repeat this check on sheet3,
sheet4...sheet8. I can't do a simple copy & paste special, because
there may be constants on the different sheets, or the formatting may
have been deliberately altered (so really I just want to highlight the
differences in the cells).

I want to check:

* formulas
* formatting (font style, font color, cell interior, conditional
formatting)
* borders
* protection
* comments

I'd like to think this is comprehensive (although worried I may've
missed something).

If there is no solution, I've already written the code, so please
don't trouble writing/posting any. I'm just hoping for a pointer, or
general advice, if there is a solution.

Many thanks in advance,
Chris Adams