Conditional Formatting

Screen_Shot_2019-10-18_at_3.36.12_PM.png
  1. Create a Table Chart or Pivot Table and add the data you would like to apply conditional formatting to
  2. Click on Format
  3. Open the ‘Field Formatting’ menu
  4. Choose the column you would like to apply conditional formatting to from the drop down list.
  5. You can choose to add conditional formatting to the background color, text color, or both. Toggle 'Use Font Color Scale' to use conditional formatting on the font color. Toggle 'Use Background Color Scale' to use conditional formatting on the background color.
  6. Adjust the color scale and optionally choose Maximum, Minimum and Center values
5da63269f348b.png

Was this article helpful?

Anything else?

Our customer support team is here to help.

Contact Us