# 5. 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.

<figure><img src="/files/7T6LDF6S2FMvieBTCxC3" alt=""><figcaption><p>Conditional Formatting - Overview</p></figcaption></figure>

Conditional formatting can be used to highlight or emphasize certain records using color, icons, data bars, etc.&#x20;

Click on the measure to which you want to apply the conditional formatting, and then select the **Conditional Formatting** dropdown, as shown below.

<figure><img src="/files/olk2T4myCLBw57jUvGv7" alt=""><figcaption><p>Accessing conditional formatting</p></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—these are covered in the [one-click options](/premium-table/working-with-premium-table/5.-conditional-formatting/one-click-options.md).
2. Creating advanced rules from scratch using nested if-conditions, ranking, etc.—these are covered in the [create rule](/premium-table/working-with-premium-table/5.-conditional-formatting/rules-if-conditions/bubble-charts.md) section.

Inserted rules can be edited, hidden, reordered, or deleted using the [Manage Rules](/premium-table/working-with-premium-table/5.-conditional-formatting/manage-rules.md) menu.

{% hint style="info" %}
After applying the one-click formatting options, they can be further customized.
{% endhint %}

In the following section, we'll look at one-click conditional formatting options.

#### Related Inforiver Resource

[5 ways to supercharge your Power BI Conditional Formatting](https://inforiver.com/blog/general/supercharge-power-bi-conditional-formatting/)


---

# 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.inforiver.com/premium-table/working-with-premium-table/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.
