Compare lists and highlight matches
 

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.

Compare lists and highlight matches
 

Take a look he

http://www.cpearson.com/excel/duplic...tractingCommon

"srain001" wrote:

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.

Compare lists and highlight matches
 

Several ways, have a look here

http://www.cpearson.com/excel/duplic...tractingCommon

Mike


"srain001" wrote:

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.

Compare lists and highlight matches
 

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

"srain001" wrote:

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.