Highlight Duplicates in Google Sheets

Submitted by allisonc on Wed, 09/18/2019 - 11:02

Google Sheets is one alternative to Microsoft Excel.
This is something that can be done quite easily if you are using Microsoft Excel, but for Google Sheets, it is a bit more complicated.

  1. Highlight the column you want to check
    sheets_screenshot_step1
  2. In the menu, select Format | Conditional Formatting
    The "Conditional format rules" menu will appear on the right hand side
    sheets_screenshot_step2
  3. Select the range if you have not already
    sheets_screenshot_step3
  4. Under "Format rules Format cells if...", select "Custom formula is"
    sheets_screenshot_step4
  5. Type in: =countif(A:A,A1)>1
    sheets_screenshot_step5
  6. Under "Formatting style", choose the format you would like.
    Click on the word "Default" to select one of the default formats.
    sheets_screenshot_step6
  7. Click the "Done" button