Need a macro to compare columns in 2 different workbooks and highlight the entries that are different, based on the comparison
Column C of Workbook 1 had 5 names on 5 rows
Column B of Workbook 2 has 5 names on 5 rows (there will be instances when workbook 2 might have more or less names)
Can a macro compare column C of workbook 1 and column B of workbook 2 and highlight the entries that are different in the 2 workbooks?
There is a blank row after the list of names ends, so I believe a macro is able to identify when a list ends.

Any help is sincerely appreciated!