Select the data range and click Home > Conditional Formatting > New Rule. If you want to color the duplicate rows based on a column in a range, you can do as these:ġ. Now the duplicate values (including first duplicate) are colored.Ĭolor duplicate rows in the selected range Then in the popping dialog, you can select the color you need to highlight duplicates from the drop down list of values with. 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?
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |