# Configuring rules for charts

## 1. Configuring conditional formatting rules

Inforiver provides the options outlined below to configure conditional formatting rules.

**i) Title:** Custom name to uniquely identify the rule.

**ii) Apply to:** The column on which conditional formatting is to be applied.

**iii) Exclude:** Uncheck the 'Total' checkbox if you do not want to apply conditional formatting on the totals.

**iv) Format by**: To drive conditional formatting based on rules or color scales,  select the respective option.

**v) Color impacts on:** You can choose the element (like Chart or Data label) to which the formatting will be applied.

**vi) Condition:** Define conditions to drive the conditional formatting.

**vii) Add condition:** Use this link to add additional And/or conditions.

In this example, we have highlighted the data labels in red where the 2023 Actuals < 2022 Actuals.

<figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FuVn0CbsUAtTyquooWEAe%2Fimage.png?alt=media&#x26;token=0342318f-ad50-440a-9c7f-b3e3b0ec7a13" alt=""><figcaption><p>Conditional formatting rules for charts</p></figcaption></figure>

#### Conditional formatting for charts

When you choose Color impacts on > Chart, you can set a color and fill style (solid, outline, hatched).

<figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2F4CVHdEzrh4RIMo6oa39N%2Fimage.png?alt=media&#x26;token=797e20fe-c2d1-4cf5-bc9b-c9f6c982110b" alt=""><figcaption><p>Fill style and color for charts</p></figcaption></figure>

#### Conditional formatting for data tables

You can highlight the data in the data table by changing the font color when the rule is satisfied. Choose 'Data Table' from the **Impacts on** dropdow&#x6E;**.**  In this example, the profit values are highlighted when the relative variance between sales and profit is more than 5.

<figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FZz7EStS6D8oZUN0NvyS9%2Fimage.png?alt=media&#x26;token=308ee402-a646-49b7-9f28-7a2d695dcabe" alt=""><figcaption><p>Conditional formatting applied on the data table</p></figcaption></figure>
