Forum Discussion
Solved
Finding and formatting duplicates in excel
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
=MATCH(A1,Sheet2!$A$1:$A$1000,0)You can try this rule for conditional formatting.
=$A$1:$A$1000This is the "applies to" range in the example.
Sheet1:
Sheet2:
=MATCH(A1,Sheet2!$A$1:$A$1000,0)You can try this rule for conditional formatting.
=$A$1:$A$1000This is the "applies to" range in the example.
Sheet1:
Sheet2:
- Thanks Quadruple_Pawn , this works great!
