Change the format of particular rows in a View

As well as controlling the format of all rows, you can specify particular formats for rows that meet criteria you define. For example, we want to show all overdue jobs in bold red Arial:

First, open e.g. a Jobs -Summary view from the main window's tree view.

Right click on the view and select Conditional formatting (you can also do this from the View menu). The following window will appear:

Column
Click here and select the column from the drop-down list that you wish to set the condition on - in our example we are going to select "Completion Status".

Operator
This allows you to select the type of operation you want. In our example we want to change the formatting of rows where the Completion Status is "Overdue", so select "equals" from the drop down

Value1
Enter "Overdue" (without the quote marks).

Value2
This only applies if you have chosen "between" or "not between" in the Operator column. Leave it empty in our example.

Font
Click here and select the font you want rows that meet this condition to be displayed in. For our example, select Arial 12pt Bold and choose red as the font color.

Back color
This controls the background color of rows that meet the condition. We will leave it at the default (white).

As soon as you enter anything in the row on this window, the system will automatically generate a new empty row beneath it. If you wish, you can add further conditional formats.

Please note, it is not possible to combine conditions together - e.g. Completion Status = "Overdue" AND Job Status = "Open". In this case it is better to create a view filtered on Open Jobs then set a conditional format to show Overdue jobs in the required format.

Click OK and, assuming you have Overdue jobs, these should now be formatted in bold red Arial 12pt on the Jobs Summary.

Deleting a Conditional Format row
To delete a condition, click on the arrowhead at the start of the row to select the entire row, then press the Delete button on the keyboard.

Home