Conditional Formatting (Worksheets)

IMPORTANT: This document is specific to Sigma worksheets. To learn about this topic for Sigma’s new Workbooks feature, please visit:

Summary of Content

Formatting Table Visualizations
Set a Custom Domain For Color Scales
Related Resources

Formatting Table Visualizations

  1. Create a Table Chart or Pivot Table OR open an existing one.
  2. Open the Format tab in your visualization editor.
    Screen_Shot_2020-05-18_at_5.31.06_PM.png
  3. Click on the subsection titled CONDITIONAL FORMATTING to expand.
  4. Click the blue + Add another rule  button to add your first rule.
    Screen_Shot_2020-05-18_at_5.32.35_PM.png
  5. A popup box will appear prompting you to customize your rule. First select Single Color or Color Scale.
    Screen_Shot_2020-05-18_at_5.35.20_PM.png                   Screen_Shot_2020-05-18_at_5.35.53_PM.png
  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.
    Screen_Shot_2020-05-18_at_5.52.54_PM.png

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.
    Screen_Shot_2020-05-18_at_5.35.53_PM.png
  3. Open the color dropdown menu.
  4. Toggle Customize domain.
    Screen_Shot_2020-05-18_at_5.50.55_PM.png
  5. Set Minimum, Middle, and Maximum numeric for your scale.
    Screen_Shot_2020-05-18_at_5.52.12_PM.png                     5da63269f348b.png

Related Resources

Pivot Tables
Conditional Formatting of Single Value Visualizations

 

IMPORTANT: This document is specific to Sigma worksheets. To learn about this topic for Sigma’s new Workbooks feature, please visit: