# 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="https://382510089-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FIuuIZWiXEx25eV75hmmJ%2Fuploads%2Fw6wsil8VJ915WEK6AiFh%2Fimage.png?alt=media&#x26;token=253a13c3-f8a8-459b-9910-367c89dfa6ab" 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="https://382510089-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FIuuIZWiXEx25eV75hmmJ%2Fuploads%2FjlO4Jz5xVkXVaULVH4M6%2Fimage.png?alt=media&#x26;token=0da5930e-74a5-43a0-b37b-b2751b870c30" 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="https://382510089-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FIuuIZWiXEx25eV75hmmJ%2Fuploads%2FA7D2TQscMYFScB3qQdkC%2Fimage.png?alt=media&#x26;token=5c71f808-75ea-4727-b3ab-578cdd21981f" 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="https://382510089-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FIuuIZWiXEx25eV75hmmJ%2Fuploads%2FVhDxzMdWG4X0qrOpjLZG%2Fimage.png?alt=media&#x26;token=73dccaac-47d4-4980-9e25-de86d62d1b25" alt=""><figcaption></figcaption></figure>
