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.
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.
- Can I apply conditional formatting to other chart types?
Table Charts in Data Explorer only support conditional formatting.
- What formatting is applied if a cell meets multiple conditions?
The cell will receive the formatting of the first condition in the rule list that it meets.
- How can I apply a "between" operator?
Grow does not currently have a between operator, however, you can achieve the same outcome by ordering the rules in a specific way. For example, if I wanted sales above 2000 to be green, sales below 1000 to be red, and sales between 1000 and 2000 to be yellow, I could apply the 3 rules in this specific order: