# Conditional Formatting

Exception reporting using data-driven rules to identify datapoints for focus. For instance, highlighting the low performing employees.

Click on ‘Conditional Formatting’ option in the ‘Analyze’ section of the top ribbon:

<figure><img src="/files/Df8rH2hH24EC3tis7mim" alt=""><figcaption></figcaption></figure>

&#x20;You would see default rules applied based on metrics. You can delete those if you do not need it.

&#x20;Click on ‘Add New Rule’ and now we can configure a new rule:

<figure><img src="/files/Vi2NbyLvuuuwp5nKE2kT" alt=""><figcaption></figcaption></figure>

* We can provide a name for the condition that will be shown in the legend
* The condition can be set by rule (set of conditions) or color scale (range of values of a metric)
* ‘Color Impacts on’ let’s you choose the UI element on which the color must be applied – Node Background color, Border color, Font color
* And of course, select the color/color scheme for the same
* Finally click on ‘Apply’

After applying the conditional formatting:

<figure><img src="/files/GpHLWTPGg1y0Yfd4J1r9" alt=""><figcaption></figcaption></figure>

### Exclude Root Node in Multiple Category Column

To exclude the root node from conditional formatting in a multi-category column, simply disable the "Exclude Total Root Node" toggle in the Conditional Formatting settings, as shown in the image below:

<figure><img src="/files/v4CIlgjrR8Nq9Q8Qc9UJ" alt=""><figcaption></figcaption></figure>


---

# 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.xviz.com/performance-management/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.
