Share this on

Conditional formatting in InLoox PM 8


You are here: InLoox Support Knowledge Base Online Help InLoox for Outlook 8.0 Online Help InLoox PM 8 Project list features Conditional formatting

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.

  1. In the project list, on the Start tab, in the Current View group, click Conditional Formatting.
  2. In the drop-down menu select one:
    • Add Preconfigured Formatting (will be displayed later, after one have been saved)
    • Add Simple Formatting
    • Add Extended Formatting

The following part describes each of these formatting type by using the examples.

Simple Formatting

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.

  1. On the side panel, in the Condition area, in the Column field select Total Expenses (Actual).
  2. In the Condition field choose an argument Greater than.
  3. In the Value 1 field enter a value for comparison, e.g. 5000.
  4. In the Format area define the formatting, e.g. BackColor red.

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.

Extended Formatting

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.

  1. 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.

  2. On the Expression editor dialog box, in the lower left, click Fields.
  3. Right from it select Total Expenses (Actual) from the list by double-clicking it.
  4. Select one relational operator, e.g. greater than >.
  5. Now select Total Expenses (Plan) from the list by double-clicking it.
  6. Click Ok.
  7. In the Format area select BackColor, e.g. green.

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.

Preconfigured Formatting

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.