Home |
Search |
Today's Posts |
#1
|
|||
|
|||
conditional formatting-shading
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 |
#2
|
|||
|
|||
select all the cells, and apply CF with a formula of
=C1=MIN(IF($C$1:$G$10,$C$1:$G$1)) and set pattern as required -- HTH RP (remove nothere from the email address if mailing direct) "Shooter" wrote in message ... 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 |
#3
|
|||
|
|||
I answered your question yesterday. See:
http://tinyurl.com/4f637 HTH Jason Atlanta, GA -----Original Message----- 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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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) |