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

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop

Fluff

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

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
38,735
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
38,735
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,095,672
Messages
5,445,896
Members
405,368
Latest member
mistersend

This Week's Hot Topics

Top