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...
=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!