close

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(A$1:A$20gt;0,A$1:A$20))
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.

全站熱搜
創作者介紹
創作者 software 的頭像
software

software

software 發表在 痞客邦 留言(0) 人氣()

E-mail轉寄