All docs
V20.2
20.2
20.1
The page you are viewing does not exist in version 20.1. This link will take you to the root page.
19.2
The page you are viewing does not exist in version 19.2. This link will take you to the root page.
19.1
The page you are viewing does not exist in version 19.1. This link will take you to the root page.
18.2
The page you are viewing does not exist in version 18.2. This link will take you to the root page.
18.1
The page you are viewing does not exist in version 18.1. This link will take you to the root page.
17.2
The page you are viewing does not exist in version 17.2. This link will take you to the root page.

Conditional Formatting

  • 2 minutes to read

Use conditional formatting to highlight individual cells or rows based on specific conditions. You can apply format rules to dimension and measure column types.

You can use hidden measures to specify a condition used to apply formatting to visible values.

wdd-grid-conditional-formatting

Supported Format Rules

Format rules that can be applied to different data item types are as follows:

Data Type

Supported Format Conditions

numeric

Value

Top-Bottom

Average

Expression

Icon Ranges

Color Ranges

Gradient Ranges

Bar

Bar Color Ranges

Bar Gradient Ranges

string

Value with the condition type set to Equal To, Not Equal To or Text that Contains

Expression

date-time

Value

A Date Occurring for dimensions with the continuous date-time group interval

Expression

Icon Ranges

Color Ranges

Gradient Ranges

Bar

Bar Color Ranges

Bar Gradient Ranges

Refer to the following topic for more information about format condition types: Conditional Formatting Basics

Create and Edit a Format Rule

You can create and edit format rules in the Conditional Formatting section that is located in the following places:

Refer to the following topic for information on how to create and edit format rules: Conditional Formatting in Web Dashboard

Grid-Specific Format Condition Settings

The format rule's Miscellaneous section contains the following properties that are specific to the Grid item:

Option Description
Enabled Enables/ Disables the current format rule.
Applied to Row Applies the current format rule to a row.