Applying Conditional Formatting to an Aggregated Table

1. In the Report toolbox, go to the table to which you wish to apply the conditional formatting.
2. Right-click on the table in the toolbox and select Conditional Formatting, or right-click on the table in the table designer page and again select Conditional Formatting.

The upper frame in Conditional Formatting is a list of areas (columns or rows) in the table where conditional formatting is to be applied. Initially this list will be empty.

3. To add a new area, click New Area in the upper right corner of the list .



Figure 1 - Adding a new Conditional Formatting Area

The input page opens at the Area tab .



Figure 2 - The Conditional Formatting Area tab

4. In the Area tab, specify whether the conditional formatting is to be applied to the columns or rows in the table.
5. Specify which columns/rows it is to be applied to, and where the system is to count from to find those columns/rows. For example, select Rows, Top, and type in 3, to apply the formatting to the third row down from the top.

To apply the same conditional formatting to more than one column or row, use comma (,) and/or dash (-) separators. For example, select Columns,1,2,6-8 and Left to apply the same conditional formatting to data columns 1, 2, 6, 7 and 8 counting from the left side of the table .

6. To simplify future reference, give the area a name.

By default new areas are named "Area 1", "Area 2" and so on.



Figure 3 - Area Definition

In the example belowhere, two areas for conditional formatting are defined: Column 2 from left, and column 1 from right (the last column).



Figure 4 - Conditional Formatting Applied to Two Areas

7. Go to the Conditions tab.

For each area, define one or more Conditions for the conditional formatting. Each Condition must include an Expression (go to Expressions for more information) and a Style (go to HTML Styles for more information). If the Expression equates to TRUE, then the selected Style is applied to the cells specified in the Area tab. Note that you may need to create the styles before you can use them.

8. On completion, click Save.
9. Click Preview to see the condition applied to the table.

Here Below is an example of the definition for conditional formatting on the "Percent favorable" column in the example above.

Figure 5 - The Conditions tab

Once you have set up a conditional formatting area, you can duplicate it to save time when creating more areas. To do this, in the upper frame check the box beside the area you wish to duplicate and click Duplicate. A copy of the area is places in the list; select it and edit as necessary.

Conditional Formatting Settings on Aggregated Table Style

If you wish to reuse the same Conditional Formatting Settings across a table set, you may apply the setting to an Aggregated Table Style instead of setting it individually on each individual table.

To modify the Conditional Formatting Settings on an Aggregated Table style, right-click the style in the Layout and Styles toolbox and selecting Conditional Formatting .

Figure 6 - Setting Conditional Formatting for an aggregated table style