How-To

Conditional Formatting

  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. Choose ‘Conditional Formatting’ from the menu
  4. Choose the column you would like to apply conditional formatting to
  5. You can choose to add conditional formatting to the background color, text color, or both
  6. Adjust the values and colors for the Maximum, Minimum and Center