software

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

Thanks for your help.

Hi!

Assume the numbers are in the range A1:A20
Select the range A1:A20
Goto Formatgt;Conditional Formatting
Formula is: =A1=MIN(IF(A1:A20gt;0,A1:A20))
Click the Format button
Select the style(s) desired
OK out

Biff
quot;Kennyquot; gt; wrote in message ...
Hello; how to highlight the smallest positive numbers, other than zero's, from a range of cells, in quot;conditional formattingquot; ?

Thanks for your help.