Conditional Formatting_Excluding "0" value

[Bella Jeon]

Hi Excel Guru,


I'm trying to use conditional formatting to see top 3 3 value using different colors.
I want to exclude the cell , value "0"
How can I do that ?

This is the example of my fomular for Top 3

=B24=LARGE(B$24:B$36,3)

Thanks !
Bella

 

[AIM]

Hi Bella,

Please check with this formula. This should help.

=B24=LARGE(IF(B$24:B$36>0,B$24:B$36),3)

Regards!!

 

[SirJB7]

Hi, Bella Jeon!
You're doing actually so in your uploaded file, aren't you?
Regards!