Condional Formatting for Minimun but Greater than zero

[jonty]

Hallo to the board.

I am trying to do some conditional formatting.

I have a column of numbers

12
34
45
11
23
56
0
56
0
45
0

I am trying to conditionally format the smallest number but do not include the zero.
so in this range of numbers my desired format should be applied to 11.

I have tried =a1=min($a$1:$a$12) - but this takes the zero into account.

Cheers

Jonty

 

[Aladin Akyurek]

What if you have negative numbers?

 

[Andrew Poulsom]

Try:

=A1=MIN(IF($A$1:$A$11<>0,$A$1:$A$11,""))

 

[jonty]

They are always going to be positive



Thanks

 

[Aladin Akyurek]

They are always going to be positive...

=$A1=SMALL($A$1:$A$11,COUNTIF($A$1:$A$11,0)+1)

 

[Brian from Maui]

For what it's worth......

=IF(SUM($A$1:$A$11),A1=MIN(IF($A$1:$A$11,$A$1:$A$11)))

 

[jonty]

Thanks Aladin, Andrew

Both work great

Great website !!!!

Cheers
Jonty