Format

From the Table ribbon, click the Format tool to display the Rules dialog.

Figure 1. Format tool

Figure 2. Rules dialog

Figure 3. Access through Context Menu

You can use this dialog to easily detect critical key point performance indicators (KPI's). For example, in the image above, the first rule defines the content of cells D2 through E7 to have blue cell color if the value of those cells is greater than 0. There can be multiple rules applied on a single cell. Rules are executed in order of appearance.

New Rule

Adds a rule to the table. A new row is added, and you can use the options below to define the rule for a cell(s).

Delete Rule

Select a rule from the list and click Delete Rule to remove the rules previously set for the selected fields.

Filter Rules using Cell Id

Use this field to display the rules that are applied to a selected cell(s). Click the arrow icon and select a cell or range of cells from the TableView spreadsheet. The rules defined for that cell are displayed. To select multiple cells, drag the left mouse button over the TableView cells that you want to filter.

Cells

To define the cell(s) to apply a rule to select the field in the Cell column to activate it. Once activated, an arrow is displayed to the right of the cell. You can either directly enter the cell ID, or, from the TableView table, drag the left mouse button over the cells that you want to define with the rule.

Operator

From the Operator column, select the operator type from the drop-down list. Operators include:

=

Equal to.

>

Greater than.

>=

Greater than or equal to.

<

Less than.

<=

Less than or equal to.

!=

Not equal to.

Value

Select the cell and enter a value for the rule you are defining.

Strings are supported for conditional formatting; enter strings to compare.

Text and Cell Color

Click the color box to select a color from the palette for text or for a cell.