How To Highlight Duplicates In Excel In Two Columns (2026)

If you just need a quick, one‑time list:

=$A2=$B2

This method is dynamic – highlights update automatically when data changes. how to highlight duplicates in excel in two columns

If you want to highlight rows where the value in Column A matches the value in Column B on the : If you just need a quick, one‑time list: