On the top toolbar, click "Format", and then click "Conditional formatting"… and then click "Add another rule". In this example the names are listed in column A, and so we will select column A before opening the Conditional formatting menu, or alternatively you can simply open the menu and then type the range A1:A1000 in the “Apply to range” field Or you can simply open the "Conditional formatting” menu and type the range that you want to apply the formatting to, under the ”Apply to range” field. The first is by selecting the range that you want to format before opening the conditional formatting menu, and Google Sheets will automatically fill in the cell range… Note that you can specify the range that you want to apply the conditional formatting to in two different ways. In this example, we are going to highlight duplicate names within a single column, again by using conditional formatting. “Custom formula is” allows us to use a formula to specify which cells to format based on a specified criteria, such as telling Google Sheets to format the values that are counted more than once (i.e. The most common way to highlight duplicates in Google Sheets, is by using the “Custom formula is” option in the conditional formatting rules. You can also learn how to remove duplicates with a formula in this lesson.Ĭlick here to get your Google Sheets cheat sheet Method 1: Highlight duplicates with conditional formatting (custom formula is) Now the duplicates on your spreadsheet (Column A in this example) will be highlighted!Ĭheck out this lesson if you want to learn how to remove duplicates in Google Sheets instead of highlighting them.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |