Conditional formatting in google sheet not working for duplicates

1
votes

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

1
gs-conditional-formatting
Wow, I'm so embarrassed! Really wishing I had a google sheets expert close to me to be able to bounce these kind of questions off of, haha. Thanks!! – ssalazar12
Neither working for me... – SzabK

1 Answers

1
votes

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

result1 formula1