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

try MIN instead

--
Don Guillett
SalesAid Software

"Deepak" wrote in message
...
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

"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

"Deepak" wrote:

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

Try

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

"Don Guillett" wrote:

try MIN instead

--
Don Guillett
SalesAid Software

"Deepak" wrote in message
...
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