Compare lists and highlight matches

S

srain001

Hi,

I have two lists that I'm trying to compare to see if there are any
similarities. The lists are quite extensive. Is there a formula out there
which can match the entries AND highlight them?

any help would be appreciated.
thanx
S.
 
T

Toppers

Assume lists are in columns A & B:

Highlight column B
Format=>Conditional Formatting
FormulaIs: = COUNtIF(A:A,B1)>=1
Format=>Pattern .. set colour

Matching values will be coloured.

HTH
 

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 lists and highlight matches 2
Blank Page After Envelope-Label Wizard 5
No option to create a list in SharePoint Site 0
Recover Outlook calendar entry 1
Comparing two lists in Excel 1
Compare multiple cells and highlight differences 5
Creating Multi Level list using Header Style 1
Macro for comparing columns and highlighting matching/differences 13

Top