# Create rule (Reporting Matrix)

You can build your own conditional formatting rules from scratch or customize the rules created using the one-click options if your report requires it.&#x20;

In this section, we'll cover some of the basic settings related to conditional formatting.

**STEP 1:** To create a new rule, select Conditional Formatting > Create Rule from the Home ribbon. The conditional formatting side pane opens as shown.

<figure><img src="/files/azFmMLVYMnjZQp4tEpK5" alt=""><figcaption><p>Create rule</p></figcaption></figure>

**STEP 2:** The rule can be renamed to something more relevant to your business context by editing the **Title** field.

**STEP 3:** You can apply conditional formatting to the row headers, rows, column headers, or columns/measures. Choose the desired option in the **Apply to** field. For example, if you opt to apply conditional formatting for row headers, you will be able to select the row dimensions that will be impacted by conditional formatting.

<div><figure><img src="/files/dKes42DM1nThncNNSkNY" alt=""><figcaption><p>Conditional formatting for row headers</p></figcaption></figure> <figure><img src="/files/K2eaYStmklu16z7uXabv" alt=""><figcaption><p>Conditional formatting for rows</p></figcaption></figure></div>

<div><figure><img src="/files/S8kGJh22fnht1pbgLfup" alt=""><figcaption><p>Conditional formatting for column headers</p></figcaption></figure> <figure><img src="/files/EJ09o9LioYBkoyXtyMrh" alt=""><figcaption><p>Conditional formatting for measures</p></figcaption></figure></div>

**STEP 5:** You can apply conditional formatting to values and totals, totals only, or values only. By default, 'Values only' will be selected. Customize as required using the **Row hierarchy levels** field.

{% hint style="info" %}
If you select the 'Values and Totals' option, an additional Exclude field will be enabled. Select the **Row grand total** checkbox to apply conditional formatting to the grand total row.
{% endhint %}

<div><figure><img src="/files/usWjQI3sBPOAano49iqS" alt=""><figcaption><p>Conditional formatting applied to values and totals</p></figcaption></figure> <figure><img src="/files/aAMImQE8qoHhoHfuR0Ya" alt=""><figcaption><p>Conditional formatting applied to totals</p></figcaption></figure> <figure><img src="/files/fkcIo2NF6LveusqOrAub" alt=""><figcaption><p>Conditional formatting applied to values</p></figcaption></figure></div>

**STEP 6:** Inforiver Reporting Matrix provides a number of formats that you can use to create rules. You can select the desired format using the **Format by** field. The available options are Rules (If Conditions), Color Scale, Classification, and Ranking.

<div><figure><img src="/files/JFkf5CLa6uQBQhtiI3Hz" alt=""><figcaption><p>Rules (If Conditions)</p></figcaption></figure> <figure><img src="/files/eTnIg1DY3UWfWl0cVZLj" alt=""><figcaption><p>Color scale</p></figcaption></figure></div>

<div><figure><img src="/files/OzMxpO4xXPYcZf3oKh0i" alt=""><figcaption><p>Classification</p></figcaption></figure> <figure><img src="/files/gT8YqbBvGVyJ8SKh2u2Q" alt=""><figcaption><p>Ranking</p></figcaption></figure></div>


---

# 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/working-with-inforiver/5.-conditional-formatting/create-rule-reporting-matrix.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.
