![]() You can still use conditional formatting to highlight the duplicate names (which would be a name that occurs more than once in all the three columns combined.īelow are the steps to highlight duplicate data in multiple columns: In the above example, we had all the names in a single column.īut what if the names are in multiple columns to perform conditional formatting for duplicates in Google Sheets(as shown below). Find Duplicates in Google Sheets by Highlighting Them in Multiple Columns To do this, select the cells that have the formatting applied, click on the Format option, click on Conditional Formatting, and delete the rule from the pane that opens on the right. In case you want to remove the highlighted cells, you need to remove the conditional formatting. This is really crucial, as it makes sure that when the formula goes to the next cell (in the row below), the overall range that is being checked for the name count remains the same. Else, it remains unchanged.Īlso, note that I have used the range $A$2:$A$10 (where there is a dollar sign before the column alphabet and the row number). In the above example, each cell is checked and if the name appears more than once in range, it returns TRUE for the COUNTIF formula, and the cell gets highlighted. If the formula returns TRUE for the cell, it is highlighted in the specified format, and if it returns FALSE, it’s not. You may want to remove duplicates to clean your data. When you use the custom formula in Conditional formatting, it checks each cell using the specified formula to search for duplicates in Google Sheets. Read more: How To Copy Conditional Formatting In Google Sheets For example, if you remove one of the names that have a duplicate, the highlight from that name (in the other cell) would go away as it has now become unique. This means that in case you change the data in any of the cells, the formatting would update automatically. One great thing about conditional formatting is that it is dynamic. The above steps would highlight all the cells with duplicate names in the specified color. By default, it will use the green color, but you can specify other colors as well as styles such as bold or italics
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |