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.
Select the range / cells that contain the data with duplicates in it.To highlight duplicates in Google sheets, follow these steps:
