Format

Displays the data contained in the currently selected TableView cell.

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


This dialog can also be open from the GUI context menu. From the modeling window, right-click to display the context menu and select Format to display the 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.
Note: This option is disabled for cells that contain multiple lines of data.
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.