How to highlight the smallest number other than zero

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.
 
B

Biff

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Getting smallest number > 0 in an array constant 3
How do I make the smallest number in a column red ( No VBA Please ) 13
Excel does not accept text format! 0
Paragraph numbering in Word 1
SMALL function to find X smallest number greater than Y 6
Highlighting text in PPT 2010 0
Blank Page After Envelope-Label Wizard 5
Conditional Formatting - Selective Cell Highlighting 5

Top