conditional formatting rule

bigdan

Well-known Member
Joined
Oct 5, 2009
Messages
769
I know how to conditionally format for duplicates. Is there a way I can format only those text values that show up, say, 4x or more, instead of 2?
 

Some videos you may like

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
36,075
Office Version
365
Platform
Windows
How about
=COUNTIF($A$2:$A$200,A2)>3
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
36,075
Office Version
365
Platform
Windows
You're welcome
 

bigdan

Well-known Member
Joined
Oct 5, 2009
Messages
769
sorry, I'm having trouble with this. Why do I need two arguments? I only need to look at entries B1:B50.
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
36,075
Office Version
365
Platform
Windows
In that case use
Select B1:B50 then in conditional formatting > New rule > Use a formula
=COUNTIF($B$1:$B$50,B1)>3
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
1,090,368
Messages
5,414,034
Members
403,512
Latest member
mrmdsims

This Week's Hot Topics

Top