Skip to content

Using conditional formatting

Using Conditional Formatting

Conditional formatting is very useful for highlighting value/**percent**intervals in data columns with different colors. This feature is available only for users with extended access permissions.

Setting Value/**Percent**Intervals

To set**value**/**percent**intervals:

  • Place your mouse pointer over the header of the target data column.
  • Click the( Column options) button.

  • Select the Conditional formatting option from the appeared dropdown menu.

  • Specify target value/ percent intervals with desired colors in the appeared Conditional Formatting Rules dialog box.
  • Value intervals are used by default. Select the Apply to percents checkbox to use percent intervals.
  • Enter the start and the end value / percent of the interval.
  • Specify the desired color code in the Color box or click the change color link and select the desired color from the appeared palette.

  • If necessary, click the Add interval button and specify as many intervals as required.
  • Click the Save and apply button.

  • See that now you have several value/ percent intervals with desired colors.

Deleting Value / Percent Intervals

To delete value / percent Intervals:

  • Place your mouse pointer over the header of the target data column.
  • Click the( Column options) button.
  • Select the Conditional formatting option from the appeared dropdown menu.
  • Click the Delete rules button in the appeared Conditional Formatting Rules dialog box.