Select the column that you will highlight duplicates, and click the Kutools > Select > Select Duplicate & Unique Cells.Ģ. This utility can find all duplicates or unique values, and add fill color or font color for these duplicates/unique values easily in Excel. Highlight duplicate or unique cells in one column Select unique rows including first duplicate And then click OK, the unique rows will be selected as following screenshots: Specify the Unique values only or All unique (Including 1st duplicates) under Rule section in the Select Duplicate & Unique Cells dialog box, and then you can select one background color or font color to highlight the unique rows as you want, see screenshot:ģ. Select the range that you want to highlight the unique rows.Ģ. If you want to find and select the unique records in the range, please do with following steps:ġ. And then click OK, the duplicate rows will be selected as following screenshots:įind and highlight unique rows in a range Then apply this utility by clicking Kutools > Select > Select Duplicate & Unique Cells, in the Select Duplicate & Unique Cells dialog box, choose Duplicates(Except 1st one) or All duplicates(Including 1st one) option under Rule section as you need, and then you can select one background color or font color to highlight the duplicate rows as you want, see screenshot:ģ. Please select the range that you want to highlight the duplicate rows.Ģ. You can quickly select the duplicate records with following steps:ġ.
See screenshots:įind and highlight duplicate rows in a range More than 300 powerful features Works with OfficeĢ007-2019 and 365 Supports all languages Easy deploying in your enterprise or organization.Ĭlick Kutools > Select > Select Duplicate & Unique Cells.Super Filter: Create advanced filter schemes and apply to any sheets Sort by week, day, frequency and more Filter by bold, formulas, comment.