Conditional Formatting

Conditional formatting is a technique where the color, font, text, and values of a data point are changed based on a data-driven condition. This technique can be used for performance metrics or to provide data-driven alerts.

Gantt Chart applies formatting based on certain criteria, such as completion percentage or project status, so users can easily track progress and identify potential issues. It allows users to customize the formatting rules and colors to better suit their individual needs.

Image 1: Conditional Formatting

Steps to enable Conditional Formatting

Conditions can be set either by Rule or Color Scheme

Method 1 - Process for Format By -> Rule

1. To apply the formatting select the Condition.

Method 2 - Process for Format By -> Color Schemes

1. Different Color Schemes are used for formatting:

Image 2: Format with color scheme

Image 3: Number of ranges

Image 4: Color Blind Safe

Image 6: Choose Color Scheme

Image 7: Select Range

Legend Configuration

To display legends for the Status flag and Timeline bars of the applied rule, enable the "Show in Legend" option.

Image 8: Show in Legend