> For the complete documentation index, see [llms.txt](https://docs.xviz.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.xviz.com/performance-management/conditional-formatting.md).

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