---
title: "Setting Report Row Colors with a Rule"
slug: "setting-report-row-colors-with-a-rule-1"
description: "This document shows how to use Color Rules to evaluate data and change the color of a row based on user set criteria.  The rule must be based off a column that is being used in the Report."
tags: ["Configure Reports", "Report Properties "]
updated: 2024-12-17T21:56:17Z
published: 2024-12-17T21:56:17Z
---

> ## Documentation Index
> Fetch the complete documentation index at: https://documentation.decisions.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Setting Report Row Colors with a Rule

## Overview

**Color Rules**allow the user to define complex logic using a Rule to apply different colors to a row in a Report. The Rule will evaluate the data in a row and will add color to the row when its data meets the Rule’s condition. Similarly, a Report Row can be customized with a Color Rule by using a [Flow](https://documentation.decisions.com/v9/docs/setting-report-row-colors).

In the following example, a Color Rule will be created on a Report that contains Account Data. The Color Rule will evaluate if the accounts can use the platform Portal by highlighting the accounts that do meet the Color Rule criteria in green.

## Example

1. Begin in a Designer Project Folder, select the **Create Report** button, then select and name the default **Report**. Then, select **Create** to open it in the Report Designer.![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/2024-12-17_15h41_47.png)
2. Under the **Data Sources** column select **Add.** Search for and select **Account****Data Source**.
3. Then, for the **Data Fields**, add the '**EmailAddress**' and the '**CanUsePortal**' fields.

![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/2024-12-17_16h01_22.png)
4. In the **Properties** panel under the**Formatting**section, select the plus icon****in the**Color Rules**properties.

![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/2024-12-17_16h03_50.png)
5. In the resulting window, select **Pick or Create Rule >****Rule Information > Create New > Statement Rule.**
6. Name the Statement Rule and click **Create** to enter the Rule Designer. This rule will color the rows that have the 'CanUsePortal' set to False.![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/2024-12-17_16h08_15.png)![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/2024-12-17_16h10_02.png)
7. In the Rule Designer, select **SETUP INPUT DATA**to add an input. Then, click 'Define Input Data'
8. Name the input data as **CanUsePortalValue** with a **Boolean**type then click Save and exit**.![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/2024-12-17_16h16_10.png)**![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/2024-12-17_16h18_30.png)
9. To build the Rule, choose **Select Data Element** then select **CanUsePortalValue,** and set the verb to **Is True****.![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/2024-12-17_16h19_48.png)**
10. Save and close the Rule to navigate back to the **Add Colors Rules**dialog.
11. Under the section **Input Bindings****,** select **Update Inputs****.** The input data that was used for the **CanUsePortal**will appear. Select the 'Pencil' icon.

![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/2024-12-17_16h21_24.png)
12. Select the **CanUsePortal** column in the **Report Field**drop-down list and choose OK.

![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/2024-12-17_16h23_11.png)
13. Now that the connection is made between the field on the Report and the Rule that will evaluate it, the next step is to define the row color for those that meet the Rule’s condition.
14. Click the **Background** selector. In the **Color Picker**dialog select a color and click PICK.

![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/2024-12-17_16h24_22.png)
15. The other color settings can be filled if desired, but the Color Rule for this example is complete. Close the **Edit Row Color Rules** dialog by selecting OK.
16. Select **Run Report**in the top action panel of the Report Designer. The Report will open, as pictured below the Color Rule applied to the rows that have the 'CanUsePortal' value set to false.

![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/2024-12-17_16h32_03.png)

---