# COUNTIF not working for highlighting Triplicates

#### VBAExcellNoob

##### Board Regular
Hello,

I am using this formula to highlight triplicates or greater:

=COUNTIF(\$A\$2:\$A\$16,A2)>3

However it is not working as intended and this is the result I am getting:

https://pasteboard.co/I5fZ0Nt.png

### Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

#### philwojo

##### Well-known Member
I can't look at your link from work it is blocked for me, but your formula is only going to give your for a result greater than 3, if you want to include 3 as well then change the ">" to ">="

#### VBAExcellNoob

##### Board Regular
https://imgur.com/ClgQtjw

Last edited:

#### VBAExcellNoob

##### Board Regular

Phil can you access this link: https://imgur.com/ClgQtjw

#### DanteAmor

##### Well-known Member
Try this

=COUNTIF(\$A\$2:\$A\$16,A2)>=3

Applies to:

=\$A\$2:\$A\$16

Replies
11
Views
154
Replies
2
Views
43
Replies
2
Views
56
Replies
1
Views
62
Replies
10
Views
132

1,109,436
Messages
5,528,749
Members
409,834
Latest member
vexceled

### This Week's Hot Topics

• Change military grades into rank
Afternoon all Need help with formula that will change military rank (i.e. 1, 2, 3 into Amn, A1C, SrA). Running IF formula that does not work...
• VBA COUNTIF SOLUTION
Hi The following are the errors spread across the several columns from E to Q ie. 13 columns across several sheets with more than 500 rows per...
• INSERT ROW WITH SPECIFIS TEXT IN A COLUMN
Hi All! How can identify that that the row to be inserted has to be inserted before 1st row with specific text in column F. If I record the...