Standard/Conditional Formatting

Standard formatting allows the administrator to configure the font colour, format and cell background colour for a particular column e.g. Start Date

Conditional formatting allows the administrator to set rules to flag/highlight a project red if past a specific due date i.e. revised ship date or if a status has been met i.e. Cancelled (strikethrough).

1. Click on the Advanced button

2. Select 'Conditional Formatting' or 'Standard Formatting' from the '+Add Formatting' dropdown menu

3. For standard formatting, select your preferences:

4. For conditional formatting, apply conditions and then select preferences:

Multiple conditions can be applied to a column.

Note: Higher rules/formats take priority over lower rules/formats