Highlighting chances in shared worksheets

D

Dream

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

How
 
R

ryguy7272

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---
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Finding Duplicate Rows & Highlighting them 6
Macro for comparing columns and highlighting matching/differences 13
Need Help with a VBA subroutine 0
Autonumber field in Excel that behaves the same as Access 0
Syncing between source worksheet and dependent worksheets 0
Comparing 2 columns from 2 different Worksheet and Returing Value of a 3rd column 2
Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0
Making "Change Highlighting" feature darker 1

Top