# Conditional formatting

Conditional formatting in dashboards and reports is key to guiding users' attention to specific performance areas. Compared to charts, tabular reports have higher information density, which makes conditional formatting a lot more useful.

Conditional formatting can be used to highlight or emphasize certain records using color, icons, data bars, etc. Select on the **Conditional formatting** dropdown as shown below.

<figure><img src="/files/7U3MnBvmgJB02FcjTBGo" alt=""><figcaption><p>Conditional formatting-overview</p></figcaption></figure>

<figure><img src="https://github.com/lumelinc/PowerTableDocs/blob/main/.gitbook/assets/5.1.1%20Toolbar.png" alt=""><figcaption></figcaption></figure>

There are two ways to apply conditional formatting -

1. Using quick, one-click options such as quick rules, color scales, classification, and data bars, which are covered in [one-click options](/planning-sheets/how-tos/adding-business-logic-and-formulae/5.-conditional-formatting/one-click-options.md)
2. Creating advanced rules from scratch using nested if-conditions, ranking, etc., which are covered in [create rule](/planning-sheets/how-tos/adding-business-logic-and-formulae/5.-conditional-formatting/create-rule-basic-settings.md)

Inserted rules can be edited, hidden, reordered, or deleted using [manage rules](/planning-sheets/how-tos/adding-business-logic-and-formulae/5.-conditional-formatting/manage-rules.md).

{% hint style="info" %}
One-click formatting options can be customized further.
{% endhint %}


---

# 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/adding-business-logic-and-formulae/5.-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.