Compare lists and highlight matches

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
Back
Top