Conditional formatting in google sheet not working for duplicates

Question

I'm trying to add conditional formatting to highlight rows that have duplicate values. I followed direction from other questions/forums:

Format>Conditional formatting>

• Single Color
• Apply to range = A1:A988
• Format rules = Custom formula is COUNTIF(A:A,A1)>1
• Formating style = Fill color light green

However, none of the rows with duplicate values are being highlighted.

https://docs.google.com/spreadsheets/d/13EKfWxkgAc6i3I3laVJTpKvHd5Z2cqDrS2H7fwu_8sQ/edit?usp=sharing

Table

Conditional Format Rule

Answer 1

For me it didn't work either until I changed the comma "," for the semicolon ";" dividing the range from the criterion: =countif(C1:C149;C2)>1

Answer 2

This answer is coming too late to help you as its been years. However I had the same problem and just figured it out. I found I couldn't have the full column as the first value inside the parenthesis. It needed to match the range I was applying the formula too. So in the case of your example it needs to be =COUNTIF(A1:A988,A1)>1

Answer 3

Maybe you should try =COUNTIF(A:A;A1)>1

Answer 4

Your formula is correct, probably you missed to put = initially, so your formula would be =COUNTIF(A:A,A1)>1