And, with a minor amendment it works across different spreadsheets - my
ultimate goal <BG. Thanks Dave

=A1<INDIRECT("'[file1.xls]sheet2'!rc",0)




"Dave Peterson" wrote in message
...
One more way if you're not using format|conditional formatting.

Select your range on sheet1 (I used A1:X99).

With A1 the activecell
format|Conditional formatting
formula is: =A1<INDIRECT("'sheet2'!rc",0)

give it a nice format



RFJ wrote:

I've got two worksheets of identical layout each comprising multiple
tables
of numerical information.

Is there a way I can automatically highlight cells in one worksheet where
the corresponding value in the other worksheet is different.

TIA

RobJ

--

Dave Peterson