Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
When a complex condition exists, we should have additional conditions upon
which to format a result. For example, in the event that a range is from: 1-10 white color 11-20 blue 21-30 green 31-40 orange 41-50 red etc. Alternatively, to enable the following construct: If a value is found in an array, format type 1 If a value is found in a different array, format type 2. etc. In the event that a value is found in more than one array, the first one listed will take effect. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Copy conditional formatting across multiple rows? | Excel Discussion (Misc queries) | |||
Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) | |||
Adding more than three Conditions to 'Conditional Formatting' | Excel Discussion (Misc queries) | |||
How do I use conditional formatting for multiple rows? | Excel Worksheet Functions |