Conditional Formatting

Conditional Formatting of Table Visualizations

1. Create a Table Chart or Pivot Table OR open an existing one.
2. Open the ‘Format’ tab in your visualization editor.
   
   
3. Click on the subsection titled 'CONDITIONAL FORMATTING' to expand.
4. Click the blue + Add another rule  button to add your first rule.
   
5. A popup box will appear prompting you to customize your rule. First select 'Single Color' or 'Color Scale'.
                      
6. Under 'Apply to field(s)', select the field or fields you would like to apply the rule to.
   The available fields are dependent on the columns you add to your visualization's Plot.
7. If you chose a 'Single Color' rule, select your 'Formatting Rule', 'Font Color', and 'Background Color'.
   If you chose a 'Color Scale' rule, select your 'Scale Type' and a color scale.
8. Watch as your chart adjusts to your changes.
   

Set a Custom Domain For Color Scales

1. In the Visualization editors 'Format' tab, open the CONDITIONAL FORMATTING subsection, and create a new rule.
2. Select 'Color Scale'.
   
3. Open the color dropdown menu.
4. Toggle 'Customize domain'.
   
5. Set Minimum, Middle, and Maximum numeric for your scale.
                        ‍

Related Documentation

Pivot Tables

Conditional Formatting of Single Value Visualizations