Try this (note: the range is specifically defined...adjust to suit your needs)
Sub Compare2Shts()
For Each Cell In Worksheets("CompareSheet#1").Range("A1:J10")
If Cell.Value < Worksheets("CompareSheet#2").Range(Cell.Address) Then
Cell.Interior.ColorIndex = 3
End If
Next

For Each Cell In Worksheets("CompareSheet#2").Range("A1:J10")
If Cell.Value < Worksheets("CompareSheet#1").Range(Cell.Address) Then
Cell.Interior.ColorIndex = 3
End If
Next
End Sub



Regards,
Ryan---
--
RyGuy


"Evgeny Grischenko" wrote:

Hi!
for comparing spreadsheets you can try this add-in:
http://www.office-excel.com/excel-ad...eadsheets.html
Hope it helps!

Best regards,
Eugene
"Darshan" wrote in message
...
Hello,

I have two worksheets which have similar values but are repeating. How do
i
compare the two and get the items which are not reconciled. Eg

Sheet 1 Sheet 2
Column A Column A
50 50
100 25
25 50
50 100
100 300
25
25
100
200

I need to compare these two sheets and identify the reconciling items. I
am
unable to use the vlookup function because of items being repeated.