# 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="/files/HneCjWms4lp99w0j5ciS" 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="/files/bDio6KqWB1sKyaXCvVFR" 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="/files/VV1qOWQEtKvVGl0r7MO0" alt=""><figcaption><p>Conditional formatting applied on the data table</p></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.inforiver.com/analytics+/working-with-analytics+/9.-conditional-formatting/configuring-rules/configuring-rules-for-charts.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.