Specifying multiple conditional formatting rules
You can create up to three conditional formatting rules for a cross-tab element. You can, for example, create three rules to display each revenue value in one of the following formats, depending on its value, as shown in Figure 2-19:
*
*
*
Figure 2-19  
For each cross-tab data value, Data Analyzer evaluates the rules in the order in which they appear in the list of rules. As it evaluates each rule, Data Analyzer applies the specified format attributes if the condition evaluates to true.
When creating multiple rules for a column, be careful that the conditions do not cover overlapping values. Consider the following rules for a revenue value:
*
*
If the value is 6000, the value appears in green, not blue as you might expect, because the condition in both rules is true (6000 is greater than 5000 and 1000), and the second rule supersedes the first rule. For the rules to make sense, the second rule should set the value to green if the value is between 1000 and 4999.

Additional Links:

Copyright Actuate Corporation 2012