Lowest value cell should get highlighted

[Deepak]

Hello all,

I have values in cell
C1 - 10
D1 - 15
E1 - 2
In this case when i use formula in conditional formatting =D1=SMALL($C1:$E1,1)
The cell E1 gets highlighted. <<< but >>> if
C1 - 0
D1 - 15
E1 - 2
In this case when i use formula in conditional formatting =D1=SMALL($C1:$E1,1)
The cell C1 gets highlighted but it should highlight E1 and overrule 0.

How is it possible plz help.

regards
Deepak
(e-mail address removed)

 

[Don Guillett]

try MIN instead

 

[driller]

"Lowest value cell should get highlighted"

if you use excel : 0 has a value....

leave c1 as blank if u don't consider 0 as a value.
to retain your cond. formula
numbers - negative,0,positive: is read as value in excel.
happy holidays

 

[daddylonglegs]

Try

=D1=MIN(IF($C1:$E1<>0,$C1:$E1))

try MIN instead