How To Highlight Duplicates In Excel In Two Columns

Go to tab → Conditional Formatting → New Rule .

(Assumes first data row is 2.)

=COUNTIF(B:B, A2) > 0

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

Are you tired of manually scanning through your Excel data to identify duplicate values in two columns? Worry no more! Highlighting duplicates in two columns is a straightforward process that can be accomplished using Excel's built-in Conditional Formatting feature. In this guide, we will walk you through the steps to highlight duplicates in two columns. Go to tab → Conditional Formatting → New Rule

| | Column B | | --- | --- | | John | Jane | | Jane | John | | Joe | Mike | | Mike | Joe | Method 1: Use Conditional Formatting (Built-In Rule) Are

Conditional Formatting → New Rule → Use a formula.