#HIGHLIGHT DUPLICATES IN TWO COLUMNS IN EXCEL FOR MAC HOW TO#
Let’s look at how to accomplish this with the help of these simple steps. We’ll cover these with the help of the following examples. It is a straightforward tool for highlighting duplicate values or duplicate rows in a sheet.īut, it’ll only work properly when you keep some important things in mind.
![highlight duplicates in two columns in excel for mac highlight duplicates in two columns in excel for mac](https://blog.coupler.io/wp-content/uploads/2021/07/2-duplicate-results.png)
![highlight duplicates in two columns in excel for mac highlight duplicates in two columns in excel for mac](https://cdn.educba.com/academy/wp-content/uploads/2019/01/Highlight-Duplicates-in-Excel.png)
(before you hit enter, you can see in a small drop-down, an option is. (Or you can use ALT>H>L>H>D>ENTER sequential shortcut to highlight duplicates) 3. Now go to Home->Conditional Formatting->Highlight Cells Rules->Duplicate Values. You’ll see the Custom Format applied to the cell immediately. To select non-adjacent ranges, hold the CTRL key and use the mouse to select ranges.
![highlight duplicates in two columns in excel for mac highlight duplicates in two columns in excel for mac](https://www.ablebits.com/_img/excel-remove-duplicates/columns-search-duplicates.png)
If you prefer a format that isn’t listed, click “Custom Format” in the drop-down box to pick a font, border, or fill style in the subsequent pop-up window. Click “OK” to apply the format to your duplicate data. Then, click the second drop-down box to select a different format. However, you can change this if you wish.Ĭonfirm that “Duplicate” displays in the first drop-down box. When the Duplicate Values window displays, you should immediately see your duplicates highlighted with the default formatting applied.