Extend conditional formatting to more than 3 conditions
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.
|