Susan
This little macro will do that. I assumed your two sheets were named
"One" and "Two", and the range to be checked is A1:P100. Change all that as
needed.
As written, this macro will compare each cell in sheet "One" with the same
cell in sheet "Two", and will color the cell in sheet "One" red if the
values are not the same. Post back if you need more. HTH Otto
Sub CompareSheets()
Dim Rng1 As Range
Dim i As Range
Sheets("One").Select
Set Rng1 = Range("A1:P100")
With Sheets("Two")
For Each i In Rng1
If i.Value < .Range(i.Address).Value Then _
i.Interior.ColorIndex = 3
Next i
End With
End Sub
"Susan@seaboard" wrote in message
...
Hello, any help would be appreciated.

I have two spread sheets, the data elements should be the same. So we
must
verify this. Is there a way to compare a spread sheet to another spread
sheet to see the differences?

-- Thanks Susan