There is no way to do this automatically. You need to use some
VBA code to do it. For example,

Sub AAA()
Dim RngAddr As String
Dim Rng As Range
Dim Rng2 As Range

For Each Rng In Worksheets("Sheet1").UsedRange.Cells
Set Rng2 = Worksheets("Sheet2").Range(Rng.Address)
If Rng < Rng2 Then
Rng2.Interior.ColorIndex = 5
End If
Next Rng
End Sub


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"RFJ" wrote in message
...
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