conditional formatting..

[VBABEGINER]

In Col B,
10
21
35
15
50
16

I want to highlight top 3 in different color, using Cond Formating..how do that?

 

[SteveO59L]

how are you defining "top 3"?

 

[Johnny C]

In the conditional formating, use the formula

=(RANK.EQ(B3,$B$2:$B$7)<=3)

Select the whole range, conditional formatting, the first parameter is the relative reference of the active cell, then the second parameter is the absolute range reference.

 

[VBABEGINER]

Thank You so much for reply...but in conditional formating which rule I will select..?

In the conditional formating, use the formula

=(RANK.EQ(B3,$B$2:$B$7)<=3)

Select the whole range, conditional formatting, the first parameter is the relative reference of the active cell, then the second parameter is the absolute range reference.

 

[VBABEGINER]

Hi, I need this in conditionla formting...not just formula..

 

[VBABEGINER]

Hi Steve, any idea...in which rule I can place this formula..

how are you defining "top 3"?

 

[SteveO59L]

conditional formatting, new rule, use a formula to determine which cells to format

 

[VBABEGINER]

Hey Steve, Thanks so much, for replying me..I got the answer..

Hi Johny, Thanks for posting..I got the answer...

conditional formatting, new rule, use a formula to determine which cells to format