Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lowest value cell should get highlighted
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct issues | Excel Worksheet Functions | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
Drawn lines paste anywhere not on highlighted cell | Excel Discussion (Misc queries) | |||
Possible Lookup Table | Excel Worksheet Functions |