How To Highlight — Duplicates In Excel In Two Columns !!hot!!

Go to tab → Conditional Formatting → New Rule .

| Situation | What to do | |-----------|-------------| | Case‑sensitive match | Use =EXACT(A2, B2) for same‑row, or =SUMPRODUCT(--EXACT(A2, B:B))>0 for anywhere in B. | | Blanks highlighted | Add AND(A2<>"", COUNTIF(B:B, A2)>0) to formula. | | Headers causing false duplicates | Start range from row 2, e.g., A2:A100 , B2:B100 . | how to highlight duplicates in excel in two columns

Choose .