containing your data (e.g., click and drag across columns A and B). Navigate to the Home tab on the Excel Ribbon. Click on Conditional Formatting in the Styles group.
=$A2=$B2
Highlighting duplicates in Excel can help you identify and manage duplicate data efficiently. When working with two columns, you can use various methods to highlight duplicates. Here are a few approaches: how to highlight duplicates in excel in two columns
Choose .
By using one of these methods, you can efficiently highlight duplicates in two columns in Excel. containing your data (e
Orange, Grape, Banana, Mango → not highlighted. containing your data (e.g.