Conditional Format On Highlighting High LOW

[suresh kannah]

Conditional Format On Highlighting High LOW of the values.
The details are attached in the attachment.

Thanks in Advance
Suresh

 

[Chihiro]

CF with following formula.
=AND($C2<>0,$C2<SMALL(IF($C$2:$C$23<>0,$C$2:$C$23,""),3))

See attached.

 

[Bhawani]

Hi,

Follow this simple steps in attached images and try yourself

 

[suresh kannah]

Nr.Chihiro

I have replicated the same in my sheet but not working,the file is also attached,

I have also pressed Ctrl+ALT+DEL

Thanks for your time
Suresh

 

[Chihiro]

That's because you are including blank ranges in the formula. Also, you should adjust reference range (since you don't have header row(s) in your workbook).

Adjusted formula is going to be...
=AND($C1<>0,$C1<>"",$C1<SMALL(IF(($C$1:$C$625<>0)*($C$1:$C$625<>""),$C$1:$C$625,""),3))

FYI - You don't need to confirm as array in CF, all formulas are treated as array formula naturally in CF.

 

[suresh kannah]

Hello Chihiro

Thanks it works fine.
Thanks again for your efforts.


Suresh