# 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="https://3062809325-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FEbkCXCUXmtUq5tcnUtZE%2Fuploads%2FvaJKnQ9fx6LLuvKVbCx5%2Fimage.png?alt=media&#x26;token=7425e491-a9d5-4331-a083-9e24dc1788f6" 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="https://3062809325-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FEbkCXCUXmtUq5tcnUtZE%2Fuploads%2FzmcE87ScgIQmJB4UUwNN%2Fimage.png?alt=media&#x26;token=fba1b887-697c-4cae-aff7-d5979cc730ca" alt=""><figcaption><p>Conditional formatting for row headers</p></figcaption></figure> <figure><img src="https://3062809325-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FEbkCXCUXmtUq5tcnUtZE%2Fuploads%2Fn4LFAhcGSQK9braShyJQ%2F2025-07-28_11h48_44.png?alt=media&#x26;token=c66206ec-e505-4fff-95a6-50a85243b95f" alt=""><figcaption><p>Conditional formatting for rows</p></figcaption></figure></div>

<div><figure><img src="https://3062809325-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FEbkCXCUXmtUq5tcnUtZE%2Fuploads%2FsdE3cUv2uDvhG7sAmspX%2Fimage.png?alt=media&#x26;token=ef599086-3a53-4e9a-a7cd-6613b98fe3cf" alt=""><figcaption><p>Conditional formatting for column headers</p></figcaption></figure> <figure><img src="https://3062809325-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FEbkCXCUXmtUq5tcnUtZE%2Fuploads%2FR1xtRZLSNOVabdh9kKOD%2F2025-07-28_11h51_14.png?alt=media&#x26;token=4df3ddb5-01d5-40a5-ab99-20868a5880ba" 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="https://3062809325-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FEbkCXCUXmtUq5tcnUtZE%2Fuploads%2FXQonCLxSCSJvyXXyolvQ%2Fimage.png?alt=media&#x26;token=b5690df8-a8db-4dae-9185-df0e2c9795b0" alt=""><figcaption><p>Conditional formatting applied to values and totals</p></figcaption></figure> <figure><img src="https://3062809325-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FEbkCXCUXmtUq5tcnUtZE%2Fuploads%2FzXQu0bsUdonxMaxx56JQ%2F2025-07-28_11h57_26.png?alt=media&#x26;token=b48f40a3-d954-4ba0-bfa5-71fdbdcd5f23" alt=""><figcaption><p>Conditional formatting applied to totals</p></figcaption></figure> <figure><img src="https://3062809325-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FEbkCXCUXmtUq5tcnUtZE%2Fuploads%2FwdQEFe2Xrb1GT50cZVw8%2F2025-07-28_11h58_52.png?alt=media&#x26;token=44d5ee44-3e8d-41fb-8ad2-afccf786a57b" 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="https://3062809325-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FEbkCXCUXmtUq5tcnUtZE%2Fuploads%2FFW2cFGHaHpRWaG3fU7aG%2Fimage.png?alt=media&#x26;token=84925a88-0b47-44f8-bb9d-b0a6fb22742d" alt=""><figcaption><p>Rules (If Conditions)</p></figcaption></figure> <figure><img src="https://3062809325-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FEbkCXCUXmtUq5tcnUtZE%2Fuploads%2FbUtrrIHvx5rALFrrW1iS%2F2025-07-28_12h05_15.png?alt=media&#x26;token=f0b04552-8c58-4575-8db9-65f324a662f5" alt=""><figcaption><p>Color scale</p></figcaption></figure></div>

<div><figure><img src="https://3062809325-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FEbkCXCUXmtUq5tcnUtZE%2Fuploads%2FRGrUJXQQTWReO0E5wUrF%2Fimage.png?alt=media&#x26;token=3a5d59b7-a5b1-4884-8248-2b28819f092f" alt=""><figcaption><p>Classification</p></figcaption></figure> <figure><img src="https://3062809325-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FEbkCXCUXmtUq5tcnUtZE%2Fuploads%2F6B0YMSKYhTNmKcCk5c8o%2F2025-07-28_12h11_05.png?alt=media&#x26;token=85e94af4-383f-4fc0-ab89-25066d1bb972" alt=""><figcaption><p>Ranking</p></figcaption></figure></div>
