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.

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:

Legend Configuration

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

Last updated