Highlight the largest value and lowest value of the range obtained from countif values

[md.ha.um.yu]

Requirement: To highlight the largest value and lowest value of the range.

The values in the range are obtained from countif() formula.

What I did: I am using conditional formatting rules: Top 1 and Bottom 1 to highlight the largest value and lowest value of the range.

Result: It is perfectly working for the largest value, but since there are zero values (obtained from countif), all cells having zero values are highlighted as lowest value.

I want to ignore the zero value and highlight the lowest value.

Any idea on how to do this?

Thank you.

[bebo021999]

Use AGGREGATE instead of countif.
For example:
A1 is criteria
B1:B10 is range of value need to be counted

Smallest:
=AGGREGATE(15,6,($B$1:$B$10)/($B$1:$B$10=$A$1)/($B$1:$B$10<>0),1)

Largest:
=AGGREGATE(14,6,($B$1:$B$10)/($B$1:$B$10=$A$1)/($B$1:$B$10<>0),1)

use this to apply to conditinal formatting of cell, i.e, B1

B1=AGGREGATE(15,6,($B$1:$B$10)/($B$1:$B$10=$A$1)/($B$1:$B$10<>0),1)
pick format

and

B1=AGGREGATE(14,6,($B$1:$B$10)/($B$1:$B$10=$A$1)/($B$1:$B$10<>0),1)
pick format

[md.ha.um.yu]

Thank you.

I used the formula =cell=Min(if(range>0,range)) and it is working well