Skip to main content
Conga Support

Conditional Formatting Styles and Types

This page applies to: Analytics Add-on module

 

Conditional Formatting Styles

Description

Cell

The background color in a matching cell will be highlighted.

Text

The text in a matching cell will be highlighted.

Icon

The text in a matching cell will replaced with an icon.

Bar

The value in a matching cell will be displayed as an inline bar.

Value

Compares data to set values.

Examples: Greater Than 10, Between 90 and 100, Not Between 0 and 30, Less Than Or Equal To 50, Is Null, and Is Not Null.

Compare Column

Compares data to set values stored in another column.

Example: Compare the received amount with the amount invoiced to highlight the values that are not equal.

Percentage of Column

Compares the value to a percentage threshold of a comparison column.

Example: Highlight revenue that is 10% less than Planned Revenue.

Percentage of Total

Compares the value to a percentage of the total of the column.

Example: Highlight values that represent less than 5% of Revenue.

Percentage of Max

Compares the value to a percentage of the maximum value.

Example: Highlight values relative to the maximum value (e.g., values that are in the lowest 20% bracket of results).