Page History
...
Table of Contents | ||
---|---|---|
|
Section | |||||||
---|---|---|---|---|---|---|---|
|
...
|
|
...
|
...
|
Field Settings - Basic Rules
Styleclass | ||
---|---|---|
| ||
Basic rules allow you to set the format of a column using comparisons to either its own values or another field’s values. This is the most common forms of Conditional Format that are applied.
Option | Description |
---|---|
Alert Type | Select the complexity of the alert rules.
|
Style | Select a display method for the alert. There are three options available:
|
Type | Select the comparison type from the following options:
|
Target | If you select a column comparison type you will have to choose the column that you want to compare your data to. Choose the appropriate column. |
Expand | ||||||||
---|---|---|---|---|---|---|---|---|
| ||||||||
Once you have selected how you want to highlight your data you must set the alert rule. The rule input section will differ based on earlier selections, however, generally you will need to choose the colour the operator (greater than etc) and input the values.
|
...
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 | ||||
---|---|---|---|---|
| ||||
|
Expand | ||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||||||||||||||||||||||||||
|
|
...
|
|
|
...
|
...
|
...
|
...
|
...
|
...
|
...