By applying the conditional formatting to your project list, you can quickly highlight the project information that meets certain conditions. This feature can be used as a warning system for the project control and displays a critical data.
The following part describes each of these formatting type by using the examples.
The simple formatting compares different columns and values. This command defines the formatting (such as colors, fonts, images. etc.) using arguments (equal, not equal, greater than, between, etc.)
In this example the projects will be displayed in red, if their actual expenses are greater than a specified value.
All projects with the actual expenses are marked in red, if they meet this rule, i.e. their content is greater than a specified limit value.
The extended formatting allows to compare different fields from the project list by using different formula. This example shows you how to use a formula to format a cell. Two fields actual and planned expenses will be compared.
On the side panel, in the Condition area, in the Expression field, click Select a formula .
It invokes the Expression Editor dialog box, which allows you to specify an expression that will be used to obtain calcualted field values. Here you can construct the required expression.
The defined formatting will be applyed on those projects, where the actual expenses a greater than the planned one.
Activate the check box Apply for cell in order to format the whole cell of the project in the project list.
The most preconfigured formatting in the drop-down menu are set by default. All conditional formatting you have created are saved automatically as templates under preconfigured formatting.
If you want to remove a template, click it and then click Delete Formatting below on the side panel.