Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have the following values in cells c1:f1:
C D E F 1 32 n/a 38 34 I would like to set up a conditional format to shade the lowest value cell from c1:f1 but it must ignore the cell with value "n/a". I tried highlighting the cells c1:f1 and in conditional formatting I set up "cell value equals ... min(c1:f1) and formatted cell pattern to red however nothing happens. I appreciate help with this. Thanks. -- 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) |