How to highlight the smallest number other than zero
 

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

Thanks for your help.

How to highlight the smallest number other than zero
 

Hi!

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

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

Thanks for your help.