How to highlight duplicate values in Google Sheet (EASY)

In this tutorial I show how to highlight duplicate values in Google Sheets as it is different to using Excel.

These are the following steps

1. Highlight your column
2. Right click
3. Click condition formatting
4. Set your range to the column you selected
5. Set the 'Format cells if...' to custom
6. Enter the formula =COUNTIF(A:A,A1) more than symbol 1

Sorry you can't use the more than bracket in youtube descriptions, I show it in the video though.

7. Select your colour and press done

Hopefully that explains it as it's very different to Excel