Compare and Highlight Rows
You may find it easier to use Conditional formatting instead:
For instance, with Sheet1 column A selected, and cell A1 active,
checking against column B in sheet2:
Format/Conditional Formatting...
CF1: Formula Is =COUNTIF(Sheet2!B:B,A1) 0
Format1: <pattern/<color
Do something similar with CF in Sheet2, column B.
In article ,
Lisab wrote:
I have an excel file with two worksheets. is there a way to programatically
compare the two worksheets to find matches and highlight those matches on
each worksheet.
They both have the same columns.
I want to compare the InspectionID column.
The Inspection ID column may have duplicates in both of the worksheets.
I have never done anything in excel above the beginner level. However, I am
a very skilled VBA programmer (programmed in ACCESS for over 10 years).
Thank you
|