#1
|
|||
|
|||
Conditional format a button based off a value in a field
I am trying to conditional format a button based off of a specific field. That field displays as a percentage with two decimal places, example 89.93. If the result in that field is 89.99 or below I want the specific button to fill red, if the field is between 90.00 and 94.99 then the button will be yellow and if the field is 95.00 then the button should be green. I have tried so many different scenerios, that I am at a lost. Does anyone know how to do this? I have seven different spots that I need this to work. TIA!
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Conditional Formatting based on dynamic Date | Modifier1000 | Excel | 2 | 09-12-2014 08:53 AM |
Creating new field in pivot table based off existing field | laceymarie1987 | Excel | 0 | 06-26-2014 12:13 PM |
Conditional Formatting based on Value of Another Cell | SteveBump | Excel | 3 | 03-07-2014 09:16 AM |
How can I count cells based on their fill color that was set by conditional format | trueimage | Excel Programming | 1 | 10-25-2013 12:08 PM |
Conditional formatting question based on cell date | Cosmo | Excel | 2 | 04-08-2013 12:12 PM |