Compare and highlight duplicates in two workbooks

D

Dylan

Hi, how do I compare column A in Workbook 1 with column A in Workbook 2 and
highlight the entries in Workbook 1 that are found in Workbook 2 ?

Regards
Dylan
 

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

Compare two workbooks and hi-light matches 0
Excel Highlighting duplicates 0
The Road- Matching data within a range of values 1
Compare variables in two excel workbooks 7
Excel Compare numbers on 1 tab to other tabs in workbook. 1
Finding and highlighting duplicates across multiple worksheets 4
Excel Protection 2
Unwanted workbooks on startup 2

Top