Lowest value cell should get highlighted

D

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
[email protected]
 
D

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
 
Top