---
title: "Using Conditional Formatting"
slug: "using-conditional-formatting"
updated: 2025-08-29T20:31:32Z
published: 2025-08-29T20:31:32Z
---

> ## 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.

# Using Conditional Formatting

## Overview

In a Report, the Conditional Formatting feature changes the color of a row or column based on a specific value. This feature is similar to the Color and Icon Rules; however, it is only supported with **String, Int32, Decimal,**and **Boolean**data types.

Conditional Formatting is lightweight compared to Color/Icon Rule, as it runs on the client side, whereas Rules run on the server side, which is a heavier operation on the Report.

Additionally, if both the Conditional Formatting and a Color/Icon Rule were used simultaneously, they would behave identically if the outputs were defined the same.

---

## Example

Performance Tip:Conditional Formatting is designed to be a high-performance method for styling reports with simple highlighting rules. Because all formatting is handled on the client side, it avoids server-side processing, which can be resource-intensive. This makes it especially effective for high-traffic dashboards or reports that contain large volumes of data and require fast, responsive rendering across many users.

1. In a Designer Project, select CREATE REPORT from the Global Action Bar.
2. Select and name the default Report in the resulting window, then click CREATE to enter the Report Designer.
3. In the Report Designer, click Add under **Data Source**. Then, expand **Common**and select **Account Data Source**.
4. Next, add **Email Address**, **Department**, and **Created on Date** under **Data Fields**.
5. Navigate to **Properties****> GRID VIEW,**change **Grid Settings Type** to**Specified,**and change **Icon Type** to **Image.**
6. Under **Properties > GRID VIEW > Conditional Formatting,** select **ADD.![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/2024-07-31_16h41_20.png)**
7. Choose **Row or Column** under**FORMATTING > Apply To** in the resulting window.
8. Next, select the **department**from the**FORMATTING > Column Name** drop-down list.
9. In the **Values**field, add a specific value.
10. Set **Background**and **Foreground**colors to highlight the specified accounts. The Background is the Row color, and the Foreground is the Text color.
11. Choose an **Icon Image**, if desired. Then, select OK.  
![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/2024-07-31_16h44_09.png)
12. In the Report Designer, click REFRESH PREVIEW to see the updated highlighted Row or Column. Additionally, the highlights will also appear when clicking Run Report.  
![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/2024-08-09_11h57_36.png)

---

## Feature Changes

| Description | Version | Developer Task |
| --- | --- | --- |
| Added the ability to format the **Number** Types (Int32 and Decimal) in Conditional Formatting | [9.8](https://documentation.decisions.com/v99/docs/version-98x-release-notes) | [DT-042006] |