Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I am still struggling with this one:
I have values in cells c1,d1,e1,f1,g1 I would like to shade the cell with the lowest value. One or more of the cells may be blank or have n/a which should be ignored. I have tried highlighting the cells together and in conditional formatting I set "formula is" =min(c1:g1) then I select the pattern color. This is not working. I appreciate any suggestions. -- Shooter |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional Formatting in Excel Help Please..... | Excel Discussion (Misc queries) | |||
Effect of Conditional Formatting, Data Validation | Excel Discussion (Misc queries) | |||
conditional formatting conflict? | Excel Worksheet Functions | |||
Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |