Thread
:
Lowest value cell should get highlighted
View Single Post
#
2
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
Lowest value cell should get highlighted
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
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett