CF Formula Only 3 Top Rank

[muhammad susanto]

hi all.

how to make conditional formatting e.g. yellow shading based on only 3 top rank with score always 100
here table

score	CF
100	100
90	90
100	100
80	80
100	100
100	100
100	100
85	85

thank in advance.
.sst

 

[fadee2]

Salam,
try

=AND($B1=100,COUNTIF($B$1:$B1,100)<=3)

in conditional formatting.

HTH

 

[maabadi]

Also you can use this formula at Conditional formating:

=AND($B2=100,RANK.EQ(B2,$B$2:$B$21,0)+COUNTIF($B$2:B2,B2)-1 <4)