Lowest value cell should get highlighted

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
"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
 
Back
Top