Report Writer – Conditional Formatting

Updated Nov 25th, 2020

Who is this guide for?

Accounts Supervisors, System Supervisors and Report Writers

Any reports you have written for your company can be set to display with Conditional Formatting – this enables you to highlight entries on reports based on specific criteria. Examples may be to highlight monetary values below a certain amount, or dates earlier than a particular date.

In the example below, we are using an introducer report to calculate the amounts of commission paid to each introducer. This amount is based on the fee quoted to the client. The conditional formatting will be set to highlight matters where the fee quoted has not been entered.

Step 1

Open the report you wish to add the conditional formatting to.

Step 2

Select the field you wish to change the formatting of, dependent on the conditions. Click the chevron button in the top right hand corner of the field, and select the ellipsis (…) button alongside Formatting Rules. Then click Edit Rule Sheet.

Step 3

Click the + button to add a new formatting rule. On the right hand side of the resulting box, click the ellipsis (…) button alongside Condition.

Step 4

Use the condition editor to enter the condition for which you’d like to format your field differently. In this example we will look for a Fee Quoted of 0 and apply a format to it.

Step 5

Now, set the format to apply to that condition (the box on the bottom right shows the result of your formatting):

Step 6

Now give your conditional format a more explanatory name, press return and click Close:

Step 7

To apply this conditional format to the field, move the new rule you have created into the Rules applied to a control box on the right, by selecting and using the single > button. Click OK:

Step 8

Now preview your report. The Fee Quoted field now appears in red text if it is zero: