Conditional formatting (AskiaAnalyse)

This feature allows you to add visual indicators or markers to your tables for the output from specific calculation types; this can enhance the table's appearance and make it more legible. For example, you might want to display negative numbers in red. When a calculation has conditional formatting defined, this is indicated in the column headed conditional formatting in the calculations section of the general tab.

See also: defining tables

To set conditional formatting, carry out the following procedure:

1. In the general tab, locate the calculation to which you want to apply conditional formatting.

2. Right-click the calculation and select conditional formatting. The following dialog appears:
   

3. Define the condition, its extent, and the formatting that will apply when the condition is true, as described below.

4. Click OK.

Defining a condition

The condition determines when the conditional formatting will be applied. For example, if you wanted to highlight values between 1 and 100 in bold text, you would define the condition as between 1 and 100. You can define as many separate conditions as you wish for a calculation. Use the controls beside the condition list to add, remove and duplicate conditions:

Control	Effect
	Add a new condition to the condition list.
	Duplicate the selected condition (an exact copy is added to the list).
	Delete the selected condition.
	Move the selected condition upwards in the list.
	Move the selected condition downwards in the list.

To edit the details of a condition, first ensure in is selected in the condition list. Then set the details using the drop-down list, as follows:

• Between: Use this operator to specify a range; the formatting will be applied if a value falls within the range. Enter the lower and upper limits of the range in the adjacent text boxes.

• Not between: Use this operator to specify a range; the formatting will be applied if a value falls outside of this range. Enter the lower and upper limits of the range in the adjacent text boxes.

• =: Use this operator to specify a single value you want to match exactly. The formatting will be applied if a value is exactly equal to this value. Enter the value in the adjacent text box.

• <>: Use this operator when you want to apply formatting to all values that are not equal to a specific single value (e.g. apply formatting to numbers that are not 100). Enter the value in the adjacent text box.

• <: Use this operator when you want to apply formatting to all values that are below a specific single value (e.g. apply formatting to numbers that are below 50). Enter the value in the adjacent text box.

• >: Use this operator when you want to apply formatting to all values that are above a specific single value (e.g. apply formatting to numbers that are above 25). Enter the value in the adjacent text box.

• <=: Use this operator when you want to apply formatting to all values that are below or equal to a specific single value (e.g. apply formatting to numbers that are 50 or below). Enter the value in the adjacent text box.

• >=: Use this operator when you want to apply formatting to all values that are equal to or above a specific single value (e.g. apply formatting to numbers that are 25 or above). Enter the value in the adjacent text box.

You can also define where the condition will be calculated, as follows:

• In total row: The condition will be calculated in the total row.

• In total column: The condition will be calculated in the total column.

• In cross-tabs: The condition will be calculated in the cross-tab.

The extent of the condition determines which items will be formatted if the condition is true. To set the extent of a condition, ensure the condition is selected in the condition list. Then select as follows (in the following table, qualifying cell refers to the cell for which the condition evaluates true):

• This calculation: The qualifying cell will be formatted.

• All calculations: All calculations in the table will be formatted.

• Row caption: The caption for the row containing the qualifying cell will be formatted.

• Column caption: The caption for the column containing the qualifying cell will be formatted.

• Row and column caption: The captions for both the row and column containing the qualifying cell will be formatted.

• Whole row: All the cells in the row containing the qualifying cell will be formatted.

• Whole column: All the cells in the column containing the qualifying cell will be formatted.

• Whole row and column: All the cells in both the row and column containing the qualifying cell will be formatted.

The on section defines whether the formatting affects flat calculations, totals, or both. By default, all are affected, but you can easily exclude certain items by de-selecting them. The available items are as follows:

• Total row: If selected, items in the total row will be affected by the conditional formatting.

• Total column: If selected, items in the total column will be affected by the conditional formatting.

• Cross-tabs: If selected, flat calculations will be affected by the conditional formatting.

In the formatting section, you can define how the values or captions will be transformed if the condition evaluates true. To set the formatting for a condition, ensure the condition is selected in the condition list. Then select as follows:

Control	Effect
	Set the font to bold.
	Set the font to italic.
	Set the font to underline.
	Set the font colour.
	Set the font background colour.