# 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) <a href="#steps-to-apply-conditional-formatting" id="steps-to-apply-conditional-formatting"></a>

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 arcs will change.

<figure><img src="https://powerviz-assets.s3.us-east-2.amazonaws.com/docs/doc-sunburst/45.png" 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 color of the rule at the top of the list will be applied.</mark>
  {% endhint %}

#### Tutorial[​](https://docs.powerviz.ai/sunburst/advanced-settings/conditional-formatting#tutorial) <a href="#tutorial" id="tutorial"></a>

![Gif](https://powerviz-assets.s3.us-east-2.amazonaws.com/docs/doc-sunburst/60.gif)

### Measure Rule[​](https://docs.powerviz.ai/sunburst/advanced-settings/conditional-formatting#measure-rule) <a href="#measure-rule" id="measure-rule"></a>

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.

<figure><img src="https://powerviz-assets.s3.us-east-2.amazonaws.com/docs/doc-sunburst/46.png" alt=""><figcaption></figcaption></figure>

### Category Rule[​](https://docs.powerviz.ai/sunburst/advanced-settings/conditional-formatting#category-rule) <a href="#category-rule" id="category-rule"></a>

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.
