# 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](https://382510089-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FIuuIZWiXEx25eV75hmmJ%2Fuploads%2F8cqzdhfJ5Iiy68w4089E%2F0.png?alt=media)

### [steps-to-enable-conditional-formatting](https://docs.xviz.com/project-management/alerting-techniques/steps-to-enable-conditional-formatting "mention")

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]\(<https://382510089-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FIuuIZWiXEx25eV75hmmJ%2Fuploads%2FF23wyYHUaLimJbRIiKkb%2F11.png?alt=media>) !\[Graphical user interface, text, application, chat or text message

Description automatically generated]\(<https://382510089-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FIuuIZWiXEx25eV75hmmJ%2Fuploads%2FT8cc671WbMOHXWkLszCi%2F12.png?alt=media>) !\[Graphical user interface, text, application

Description automatically generated]\(<https://382510089-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FIuuIZWiXEx25eV75hmmJ%2Fuploads%2FDEipeO6pXimbqbY6orX9%2F13.png?alt=media>)

### Method 2 - Process for Format By -> Color Schemes

1. Different **Color Schemes** are used for formatting:

![Image 2: Format with color scheme](https://382510089-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FIuuIZWiXEx25eV75hmmJ%2Fuploads%2FbxxwgtEHHQMeEC6aOQHf%2F14.png?alt=media)

![Image 3: Number of ranges](https://382510089-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FIuuIZWiXEx25eV75hmmJ%2Fuploads%2FJoYG8Wo4qkht3hhoMlgB%2F15.png?alt=media)

![Image 4: Color Blind Safe](https://382510089-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FIuuIZWiXEx25eV75hmmJ%2Fuploads%2FHS9daZF0X5XJ5KV82mVP%2F16.png?alt=media)

![Image 6: Choose Color Scheme](https://382510089-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FIuuIZWiXEx25eV75hmmJ%2Fuploads%2FQenOPWqmkqdxWXRdU6Kl%2F17.png?alt=media)

![Image 7: Select Range](https://382510089-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FIuuIZWiXEx25eV75hmmJ%2Fuploads%2FxLbN0CwXjVP8pUOO9luK%2F18.png?alt=media)

### Legend Configuration

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

<figure><img src="https://382510089-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FIuuIZWiXEx25eV75hmmJ%2Fuploads%2FUpOePXSG9Zxz7PboDlCk%2Fimage.png?alt=media&#x26;token=9d045795-aed2-4cd5-b002-1a3c88908a05" alt="" width="335"><figcaption><p><em>Image 8: Show in Legend</em></p></figcaption></figure>


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.xviz.com/project-management/alerting-techniques/conditional-formatting.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.