Highlight Duplicate Column Cells In Google Sheets
![Highlight Duplicate Column Cells In Google Sheets](/content/images/size/w1200/2021/06/alenlytics.com-1280x720-layout2029-1gbh1bo.png)
Assume you have data like below and want to highlight the duplicate values:
To highlight, click on "Format" and select "Conditional Formatting"
Now select formatting RULE as "Custom Formula" and enter below formula.
=countif(A:A,A1)>1
![](https://alenlytics.com/content/images/2021/06/image-4.png)