| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lowest value cell should get highlighted
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 |
| Reply |
| 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 | |||
Hybrid Mode
