ExcelBanter - Highlighting chances in shared worksheets

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Highlighting chances in shared worksheets (https://www.excelbanter.com/excel-worksheet-functions/190986-highlighting-chances-shared-worksheets.html)

Highlighting chances in shared worksheets

Two Excel Worksheets - need to idenify non matching records ( in changing
rows /columns) ?

How

Highlighting chances in shared worksheets

Hope this works for you:
Sub Compare2Shts()
For Each Cell In Worksheets("CompareSheet#1").UsedRange
If Cell.Value < Worksheets("CompareSheet#2").Range(Cell.Address) Then
Cell.Interior.ColorIndex = 3
End If
Next

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

Regards,
Ryan---

--
RyGuy

"Dream" wrote:

Two Excel Worksheets - need to idenify non matching records ( in changing
rows /columns) ?

How