Myrna, Copy this sub into a standard module and run it. HTH, James
Sub Compare2Shts()
Dim cell As Range, x As Long, y As Integer
Sheets("Sheet2").Activate
Cells.Interior.ColorIndex = xlNone
For Each cell In ActiveSheet.UsedRange.Cells
x = cell.Row
y = cell.Column
If Sheets("Sheet1").Cells(x, y) < cell Then
cell.Interior.ColorIndex = 3
Next cell
End Sub
Myrna Rodriguez wrote:
Greetings!!
Is there an easy way to compare 2 worksheets in the same workbook??
I have 2 worksheets labeled as:
Sheet1 - master
Sheet2 - this sheet has been updated
I would like to see what cells were updated in Sheet2.
thx..thx..
*** Sent via Developersdex http://www.developersdex.com ***