Sub auditt()
Dim sh1 As Worksheet, sh2 As Worksheet
Set sh1 = Sheets("original")
Set sh2 = Sheets("revised")
For Each r In sh1.UsedRange
v1 = r.Value
rr = r.Row
cc = r.Column
v2 = sh2.Cells(rr, cc).Value
If v1 < v2 Then
sh2.Cells(rr, cc).Interior.ColorIndex = 3
End If
Next

End Sub

--
Gary''s Student - gsnu200748


"Peter" wrote:

Hello all, I was wondering if there was a macro or some other way to
highlight cells when there is a change.

For example I have two tabs, one original and one revised, for all of the
numbers that change in the revised tab I would like to automatically
highlight so we can easily track them. Is there a way to do this?

Thanks...Peter