Highlight Duplicates in Google Sheets

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