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

Click again.

Here’s a clear, step-by-step guide to highlighting duplicates between two separate columns in Excel (e.g., Column A and Column B), not within a single column. how to highlight duplicates in excel in two columns

Set format → OK.

Repeat steps 1–6 for Column B, but use this formula: Click again