Page History
...
Basic rules allow you to set the format of a column using comparisons to either its own values or another field's field’s values. This is the most common forms of Conditional Format that is applied.
...
Expand | ||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||||||||||||||||||||||||||
|
...
Advanced rules allow you to create complex rules for determining the format of the column. For example if you wanted to create a rule such as: If Region = Europe and Revenue > $200,000 then highlight Profitability as RED.
Expand | ||||
---|---|---|---|---|
| ||||
|
...
When creating a range of values - – such as for a BETWEEN operator the lower end variable must be inserted as the first value of the Conditional Format followed by the higher. Example - – 30 then 40 not 40 then 30. If this is not followed you report Conditional Format will fail since no data will meet the criteria.
...