How to use Conditional Formatting in Google Data Studio

By 24th Oct 2019Blog, Google Data Studio
How to use Conditional Formatting in Google Data Studio

Today I’ll take a first look at the recently launched Conditional Formatting in Google Data Studio.

Conditional Formatting is one of the best ways to make data meaningful and understandable for your audience. It is found in Excel, Google Sheets and other spreadsheet tools. It’s a welcome addition to Data Studio!

Here is a Data Studio report with two tables, each with different Conditional Formatting rules.

Creating a single rule using Conditional Formatting

Here’s how you create the rule for the first table.

A gif image showing how to use Conditional Formatting in Google Data Studio

We can see the Color type is “Single color” – hopefully this means that two-colour and mutliple-colour formatting will be added in the future!

We can choose to have rules for our dimensions or metrics. In this case I’ve chosen to have a rule for Sessions that any grouping of sessions above 500 needs to be highlighted.

Within the ‘Color and style’ section I’ve chosen to highlight just the Sessions with red text and a yellow background.

A rule for Conditional Formatting in Google Data Studio

Creating multiple rules using Conditional Formatting

In the table show below I have three different rules applied.

A chart showing different colour rows and columns based on formatting in data studio

The first highlights if a Source/Medium contains the text “organic”. So as you see in the screenshot above, three different Source/Medium combinations that contain “organic” are highlighted.

The second rule highlights any Sessions (and their comparisons) that are greater or equal to 500.

And the third rule specifies that if any Source/Medium contains the text “referral” then the entire row must be highlighted in pale red.

rules for Conditional Formatting in Google Data Studio

The Conditional Formatting feature is brand new, so I expect there will be lots of adjustments in the coming weeks to the feature. So expect this post about Conditional Formatting in Google Data Studio to be updated!

Other Blog Posts

If you liked this article you might like my other blog posts.

I’m Michael

Iā€™m a digital analyst with seven years experience in digital marketing. I’m skilled in web analytics, tag management and data visualization.

Get in touch with me!

I'm Michael