Select the data range you want to color the duplicate values, then click Home > Conditional Formatting > Highlight Cells Rules > Duplicate Values. In Excel, you can use the Conditional Formatting feature to color the duplicate values or rows.ġ.
Supposing you have a list of data with some repeated data in a worksheet, and you want to add a different color to distinguish the duplicate values, how can you quickly color them at once instead of coloring them one by one? Here I introduce the Conditional Formatting feature and another handy tool to help you quickly color the duplicate values in Excel.Ĭolor duplicate values or rows with Conditional FormattingĬolor duplicate values or rows with Kutools for Excel
How to color duplicate values or duplicate rows in Excel?
