Hello

I wonder if someone can help me please?

I am trying to compare two worksheets (Sheet 1 and Sheet 3) and highlight where there are differences except where there is a cell with a formula.

I have managed to work out how to compare and highlight the differences but not where there is a formula. This is what I have so far.

Sub Checker()
Dim celle As Range

For Each celle In Sheet1.UsedRange
If celle <> Sheet3.Cells(celle.Row, celle.Column) Then
celle.Interior.ColorIndex = 46
End If
Next celle

End Sub

I hope someone can help me.

Thanks in advance