How To Highlight Duplicates In Excel In Two Columns

Find values that appear in both Column A and Column B (e.g., a name in A2 that also exists anywhere in Column B).

Finding duplicate data across two columns is a critical task for data cleanup, auditing, and reconciliation. Excel provides multiple native tools to accomplish this efficiently. Method 1: Use Conditional Formatting (Built-In Rule) how to highlight duplicates in excel in two columns