![]() With the data selected, go to Home –> Conditional Formatting –> New Rule.This formula combines all the cell values as a single string. Here are the steps to highlight duplicate rows:ĭrag this down for all the rows. In the above approach, we have highlighted only the strings that we created.īut what if you want to highlight all the duplicate rows (instead of highlighting cells in one single column)? This would highlight the duplicate values in column E. In the Duplicate Values dialog box, make sure Duplicate is selected and then specify the color in which you want to highlight the duplicate values.Select the range that has the combined strings (E2:E16 in this example).Here are the steps to highlight duplicate strings: A highlighted string implies that the row has a duplicate. Now that we have the combined strings for each row, we can use conditional formatting to highlight duplicate strings. If there are duplicate rows in this dataset, then these strings would be exactly the same for it. (You can also use the CONCATENATE function to combine text strings)īy doing this, we have created a single string for each row. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |