Finding and formatting duplicates in excel

[Celtic_Pixie]

Hi there,

I am looking how I format a name in a list on one worksheet when it finds the same info (persons name) on another sheet in the same workbook. I then need it to turn back to a white cell if the match no longer exists.  I have tried using a formulae in conditional formatting but nothing seems to fit.

Many thanks,

Celtic Pixie

[#2 · Accepted solution]

@Celtic_Pixie 

=MATCH(A1,Sheet2!$A$1:$A$1000,0)

You can try this rule for conditional formatting.

=$A$1:$A$1000

This is the "applies to" range in the example.

Sheet1:

Sheet2:

[#3]

Hi Quadruple_Pawn,

Thanks for this, I will give it a go.

Cheers,

@Celtic_Pixie 

[#4]

Thanks Quadruple_Pawn , this works great!