# Conditional formatting

Conditional formatting allows you to apply dynamic formatting to data in the planning sheet based on specified conditions, thresholds, or value ranges. It helps improve data visualization by automatically highlighting important values, trends, exceptions, and performance indicators.

You can use conditional formatting to apply different formatting styles such as background colors, font colors, data bars, bubble charts, heat maps, classifications, icons, and action indicators.

Conditional formatting helps users quickly analyze data and identify patterns without manually reviewing individual values.

### Key capabilities

Conditional formatting supports the following capabilities:

* Apply formatting based on value ranges or conditions.
* Categorize values using classifications.
* Display visual indicators such as icons, action dots, and action colors.
* Visualize data using color scales, data bars, and bubble charts.
* Apply formatting to rows, columns, measures, and charts.
* Include formatting in exported Excel and PDF reports.

Conditional formatting can be applied using the following methods:

* Use quick formatting options such as quick rules, color scales, classifications, and data bars. For more information, see [**quick formatting options**](https://app.gitbook.com/o/Bi5mNLq31yHE9Ep9vISb/s/Utolck8kt8atqxFPsEBn/~/edit/~/changes/197/planning-sheets/how-tos/conditional-formatting/one-click-options).
* Create advanced formatting rules using nested IF conditions, classification, and other custom logic. For more information, see [**Create rule**](https://app.gitbook.com/o/Bi5mNLq31yHE9Ep9vISb/s/Utolck8kt8atqxFPsEBn/~/edit/~/changes/197/planning-sheets/how-tos/conditional-formatting/create-rules-in-conditional-formatting).

You can manage existing rules by editing, hiding, reordering, or deleting them using [**Manage rules**](https://app.gitbook.com/o/Bi5mNLq31yHE9Ep9vISb/s/Utolck8kt8atqxFPsEBn/~/edit/~/changes/197/planning-sheets/how-tos/conditional-formatting/manage-rules).


---

# 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.fabricplan.com/planning-sheets/how-tos/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.