PricingCommunity

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.

Graphical user interface, text, application, chat or text message Description automatically generated Graphical user interface, text, application, chat or text message Description automatically generated Graphical user interface, text, application Description automatically generated

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
PreviousSteps to enable Conditional FormattingNextReference Lines and Reference Range

Last updated

Was this helpful?