View Single Post
  #1   Report Post  
Danny
 
Posts: n/a
Default 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.