Conditional Formatting Rules enable you to highlight results that meet or fail specific business targets. You can create a simple rule to highlight high or low results with a specific color or advanced conditional formatting rules that display a text comment, such as High Performer.
For example, you can create a rule to highlight margin results that exceed $1,100,000. The margin results greater than $1,100,000 are highlighted every time the report data is refreshed.
The object or cell contents, the operator, and the operand make up the condition that determines whether the formatting is applied to each cell where the rule is applied. When you apply the new rule or alerter to a table column, row, or cell on a report, Web Intelligence applies the condition to the cell values and displays any values that meet the condition in the rule with the specified formatting.
Web Intelligence applies a default format to display the formatting rule.
You can make changes to this default format. You can insert multiple conditions within a rule. You can also create an advanced formatting rule by inserting a formula.
A formatting rule contains the following elements:
- A name
- An object or cell contents
- An operator
- The operand values or another object
- The conditional formatting
There are additional principles to remember while creating rules; those principles are as follows:
- You can apply rules to tables, forms, section cells, and free-standing cells.
- You cannot apply rules to charts.
- You can include up to 30 formatting rules in a document. You can apply rules to a maximum of 20 table columns or rows, free-standing cells or section cells on the reports. A maximum of 10 formatting rules can be applied to a single-table column or row, free-standing cell or section cell.
Create a Conditional Formatting Rule
You can create a formatting rule in the Formatting Rule Editor. When you create conditions for the rule, you must specify the appropriate filtered object or cell, the operator, and the operand for the rule.
You can define the formatting in which the data should display when it satisfies the conditions for the rule. For example, you can define the formatting for the numbers, font style, background style, and borders.
Then, you can define the formatting in which the data should display when it satisfies the conditions for the rule. Finally, you can apply the rule.
You can apply the rules to the following report elements:
- Columns in vertical tables
- Rows in horizontal tables
- Cells in forms and cross tables
- Section headers
- Free-standing cells
Procedure: To Create a Single Condition Formatting Rule
Follow these steps to create a single condition formatting rule:
- Select a cell in the column to which you want to add a conditional formatting and right-click it.
- In the contextual menu, choose Formatting Rules.
- Choose Add Rule.
- Add a name and a description.
- Open the Filter list.
- Select whether you want to filter the cell contents only, or an object or variable.
- Open the Operator list.
- Select an operator.
- In the Operands section, select an operand or type a value.
- Choose Format and edit the styling options as you see fit
- Choose OK.
- Choose OK.
- Choose OK.
