Highlight values that are repeated more than twice

Hi,

for eg. if values are in range =$A$1:$A$12 , then

select range $A$1:$A$12 >>go to home>conditional formatting > new rule > use formula -

then type the below formula in the formula bar

Formula:

Please Login or Register  to view this content.

select the format as desired

Bhuvi, nice solution

2 observations....
1. you need to put the > before the =
2. because CF works only on TRUE/FALSE, you dont need the IF() function, just use =COUNTIF($A$1:$A$12,$A1)>=3

Actually your formula should work fine.

You just need to apply Conditional formatting to the entire range.

	A	B
1	29	FALSE
2	25	TRUE
3	13	TRUE
4	25	TRUE
5	15	FALSE
6	25	TRUE
7	16	FALSE
8	13	TRUE
9	13	TRUE
10	17	FALSE
11	17	FALSE

You're welcome and thank you for the feedback

Originally Posted by FDibbins

Bhuvi, nice solution

2 observations....
1. you need to put the > before the =
2. because CF works only on TRUE/FALSE, you dont need the IF() function, just use =COUNTIF($A$1:$A$12,$A1)>=3

Thanks for the information

Happy to help

psks welcome to the forum

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.