> For the complete documentation index, see [llms.txt](https://docs.powerviz.ai/powerviz/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.powerviz.ai/powerviz/activity-gauge/advance-settings-introduction/conditional-formatting.md).

# Conditional Formatting

Conditional formatting lets you change the color of arcs based on rules. You can create multiple rules based on the category or measure fields.

Steps to apply conditional formatting[​](https://docs.powerviz.ai/sunburst/advanced-settings/conditional-formatting#steps-to-apply-conditional-formatting)

1. Go to conditional formatting, using advanced settings.
2. Click on the “Add Rule” button.
3. Rule name is mandatory to have.
4. Apply a rule by measure or category.
5. Pick the column from the drop-down menu.
6. Create a condition and select the custom color.
7. Hit Save, to apply.

Result: If the conditions are met, the colors of the nodes will change.

<figure><img src="/files/4AqmgG6gfxY0VkqX5S3T" alt=""><figcaption></figcaption></figure>

{% hint style="info" %} <mark style="color:blue;">INFO</mark>

<mark style="color:blue;">You can re-order, edit, or delete existing rules.</mark>

<mark style="color:blue;">If two rules are true for the same arc. The rule's color will be applied at the top of the list.</mark>
{% endhint %}

Measure Rule​

You can set rules based on any numeric value in this section. Measure field and tooltip aggregated values can be used to apply conditions. Measure rules can be defined as equal to, not equal to, less than, greater than, less than equal to, greater than equal to, and between.\
\
Category Rule[​](https://docs.powerviz.ai/sunburst/advanced-settings/conditional-formatting#category-rule)

You can set rules based on the dimension added in the Category field. Select the hierarchy level and type the exact text of the node you wish to highlight. For categories, rules can be set by is, is not, begins with, does not begin with, ends with, does not end with, contains, does not contain.

Example

<figure><img src="/files/aZ8ZA4Jr1zMvJQDKk6Hq" alt="" width="413"><figcaption></figcaption></figure>


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## 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, and the optional `goal` query parameter:

```
GET https://docs.powerviz.ai/powerviz/activity-gauge/advance-settings-introduction/conditional-formatting.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

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.