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