Conditional Formatting will change the formatting for a cell in a report when certain conditions are met.
To access conditional formatting in Apricot Results, select the Analysis tab, and the Conditional sub-tab. Click "New Rule." Not seeing the Analysis tab? Check to make sure Design is selected in the top right.
To prevent applying formatting when saving a rule, deselect any columns or tables in a report.
Name the new rule (1) and add a description (2) to easily identify it later. Then, enter what the condition is (4). Click the ... (5) button to switch between contents of a cell, or a specific object in the report. In the example, this object is named Flag.
Choose the appropriate operator (6) such as Greater Than, Equal To, Is Null, etc. Then, enter the value that will trigger it. To select a specific value from a list, click the ... button (7). If the rule requires multiple conditions be met to trigger, use the + button (8) to add more conditions. Use the Format... button (9) to customize how the text should appear, and review the specified format in the space beside it (10).
To keep Conditional Formatting organized and simple, creating Flags or Variables to trigger the conditions is preferred. The Flag or Variable selected must exist in the table to trigger the Condition, and can be hidden.
In the example above, the condition is anytime the Flag variable returns a number greater than 0. Because the Flag uses an If/Then statement that returns a 1, anytime this Flag is activated (or returns a 1 in the table), the formatting with trigger.
Once the Formatting Rule is complete, click OK to save it.
The Formatting Rules button will now be clickable to apply the rule in the table.
Click the column where the rule should format the data, and select the Formatting Rules button.
Check the box of the Format that should apply to the data, and click OK.
In the example above, the Conditional Format is applied to the Name_198 column. A Sort is applied to the Flag column to bring the formatted data to the top of the table. To hide the Flag column, right click in the Flag column, and Select "Hide" from the flyout menu.
To remove Conditional Formatting from the column, highlight the column that is currently formatted, click Formatting Rules, un-check the box next to the name of the rule, and click OK.