Finding and formatting duplicates in excel

New Contributor

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


3 Replies
best response confirmed by Celtic_Pixie (New Contributor)



You can try this rule for conditional formatting.


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



conditional formatting sheet1.JPG




Hi Quadruple_Pawn,


Thanks for this, I will give it a go.




Thanks Quadruple_Pawn , this works great!