How to highlight the smallest number other than zero

  • Thread starter Thread starter Kenny
  • Start date Start date
K

Kenny

Hello; how to highlight the smallest positive numbers, other than zero's, from a range of cells, in "conditional formatting" ?

Thanks for your help.
 
Hi!

Assume the numbers are in the range A1:A20
Select the range A1:A20
Goto Format>Conditional Formatting
Formula is: =A1=MIN(IF(A$1:A$20>0,A$1:A$20))
Click the Format button
Select the style(s) desired
OK out

Biff
Hello; how to highlight the smallest positive numbers, other than zero's, from a range of cells, in "conditional formatting" ?

Thanks for your help.
 
Back
Top