Then you will get the similar highlight rows/cells with same values as below screenshots shown: Then a dialog box comes out to show how many rows have been selected. (3) It’s optional to check the Select entire rows option.ģ. (2) Check the Fill backcolor option, and click below drop down list and specify a fill color (1) Check the Duplicate (Except 1st one) option or All duplicates (Including 1st one) option In the opening Select Duplicate & Unique Cells dialog box, please (see screenshot above):
Select the column that you will highlight duplicate values, and click the Kutools > Select > Select Duplicate & Unique Cells. Full feature free trial 30-day, no credit card required! Free Trial Now!ġ.
Kutools for Excel- Includes more than 300 handy tools for Excel. What’s more, this utility enable to highlight the whole rows that duplicate values are in. Kutools for Excel also provides a Select Duplicate & Unique Cells utility to highlight duplicate cells in a certain column.
