Conditional Formatting in Looker Studio

Conditional formatting only available within 3 charts

1. Scorecards

2. Table

3. Pivot Table

Available Conditions in Looker Studio

1. Metrics condition: EQUAL TO | NOT EQUAL TO | GREATER THAN | GREATER THAN OR EQUAL TO | LESS THAN | LESS THAN OR EQUAL TO | EMPTY | NOT EMPTY | IS TRUE | IS FALSE | CONTAINS | DOES NOT CONTAIN | STARTS WITH | REGEX

2. Dimensions condition: EQUAL TO | NOT EQUAL TO | EMPTY | NOT EMPTY | CONTAINS | DOES NOT CONTAIN | STARTS WITH | REGEX | IS FALSE | CONTAINS | DOES NOT CONTAIN | STARTS WITH | REGEX

3. Additional conditions available in the Scorecard: IS TRUE | IS FLASE

Single color conditional formatting: Single color conditional formatting lets you apply a specific font color and background to your data. Single color conditions can include:

• Dimensions

• Metrics

• Multiple conditions using AND/OR logic.

Color scale conditional formatting: Color scale conditions let you evaluate a single metric against its percentage or absolute numeric value.

How to select colors?

• Hover over an existing data point and click Add icon to add more data points.

• To remove a data point, hover over it and click the Delete icon.

Single color: Use the color pickers to select the font color and background color to the target values for each condition. You'll see an example appear on the right.

Color scale: The data points determine your color scale's minimum, middle, and maximum values. By default, the new color scale defines 3 data points by percentage with preset colors (red, yellow, green). However, you can base the scale on whole numbers and choose a different color for each data point.

Conditional formatting limitation

• You can have a maximum of 5 data points and a minimum of 2 data points.

• Solid color conditional formatting is currently only available for tables, pivot tables, and scorecards.

• Color scale conditional formatting is currently available for tables and scorecards.

• Conditional formatting on pivot tables that use Expand-Collapse only works if the rule is based on "Any value."

• Dimension-based compound conditions in pivot tables must use the same field in each OR condition.

• Format rules can only use fields currently contained in the chart.

• A maximum of 20 formatting rules can be set per chart.

• Switching between chart visualization types (for example, switching a table to a scorecard) may require you to update conditional formatting rules, depending on the type of chart and the fields used in the rule.