Highlighting numbers that appear more than 3 times

[Spotniq]

Good afternoon,

Simple question. I have 6 digit item numbers in column F. I want to highlight all that appear more than twice. How can I go about doing that? Thanks in advance

[FlameRetired]

In Conditional Format by formula try this

=COUNTIF($F$2:$F$500,F2)>2

Applies to =$F$2:$F$500

[TMS]

Use Conditional Formatting with CF condition

Please Login or Register  to view this content.

Regards, TMS

[Spotniq]

So I've tried that, but it will only highlight the value in f2 that is present more than 3 times in the range. Or am I doing something wrong? I want it to highlight every value in column F that appears more tha twice

[shg]

Try again. The 7 and 9 only appear 3 times and are highlighted:

Row\Col	A
1	6
2	5
3	13
4	13
5	14
6	11
7	9
8	7
9	5
10	1
11	1
12	8
13	4
14	3
15	9
16	7
17	1
18	6
19	3
20	7
21	9
22	11
23	1

[FlameRetired]

So I've tried that, but it will only highlight the value in f2 that is present more than 3 times in the range. Or am I doing something wrong? I want it to highlight every value in column F that appears more tha twice

Check the relative / absolute cell addressing. It sounds like you have entered

=COUNTIF($F$2:$F$500,$F$2)>2

or

=COUNTIF($F$2:$F$500,F$2)>2

in my formula (or in TMS's)

It's

=COUNTIF($F$2:$F$500,F2)>2

or

=COUNTIF($F$2:$F$500,$F2)>2

[Spotniq]

Thank you all! I was messing up the formula, but got it now.

[TMS]

You're welcome.

[Liju144]

Guys if is that possible to highlight the values only continues repeating

[Pepe Le Mokko]

Administrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

Please see Forum Rule #4 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread