This feature is currently in beta.
If you are participating in the beta program and come across any issues, please email firstname.lastname@example.org.
Conditional formatting allows you to dynamically set the formatting (text style, text color, fill, etc) of a cell based on the value. For example, you could set the text color to red if the value in the cell is negative. It is a useful way to differentiate, highlight, or call out specific items or values in your table chart.
What chart types work with Conditional Formatting
Currently, conditional formatting only works with Table Charts in Data Explorer.
How to Use Conditional Formatting
In the Data Explorer, create a table chart and chart at least 1 data series.
To access conditional formatting, click the vertical three dot menu to the right of a data series. At the bottom of this menu you will see a “Conditional Formatting” section.
Click the “+ Add rule” button. In each rule, you will define a condition to be met and the format to be applied. Click “edit” on the rule you just created, this will open up the options for this rule. First you need to select an operator and define a criteria. For example, “Less than 0”. This is very similar to setting up a Filter transform.
Next, set up your format. You can select the text color, fill color, bold, italics, underline, and strikethrough. Once you have selected the format, hit save. This will apply the conditional formatting to your data series where the criteria is met.
Please note that operators and criteria values are dependent on the data series' data type. For example, you cannot select "greater than" if your data series is a list of Sales Reps.
- If a cell meets multiple conditions, it will receive the formatting of the first condition in the rule list that it meets
- You may have up to 10 rules for each data series.