How to highlight duplicates in Google Sheets

Here’s how you can identify and highlight duplicates in Google Sheets.

If you’re only looking for duplicates in a single column, follow these steps:

1. Select the column where you want to find duplicates.
2. 
   
3. From the menu bar, click Format > Conditional Formatting. The Conditional Formatting menu will open on the right side of your sheet.
4. 
5. 
   From the Format cells drop-down menu, select Custom formula is. A new
6.  field appears below it.
7. Enter the following formula in the new field, adjusting the letters for the column range you selected: =countif(A:A,A1)>1

8. Note: in this example, we are analyzing column A, but if you have selected column C, then replace the letter A with C in the formula above, for example: =countif(C:C,C1)>1

   5. You can now pick a colour for your highlights from under Formatting style (the default is green).

9. 6. Click Done. Any duplicate cells should now be highlighted.
   
   
10. 
11.