Conditional formatting enables you to change the visual style and color of cells with values in defined ranges. Use this feature to highlight important information for your end users.
Conditional formatting on a line item persists when you pivot it to a different dimension.
Note: The Border or Morse conditional formatting styles can result in cell values being truncated if a column isn't wide enough. To adjust column width, select and drag the line between two columns in a column header.
To configure conditional formatting:
Select a custom view and open conditional formatting.
Select values to base your formatting on.
Set formatting style and conditions.
When you set your formatting style and conditions, you enter a Minimum, Maximum, and optionally one or more Midpoint values. You can also select a color for each value. As a result, any cells between the entered values are shaded in a gradient with the selected colors.
Cells with values:
Equal to or lower than the Minimum value display in the color you've specified.
Equal to or higher than the Maximum value display in the color you've specified.
Close to the Midpoint values display in the color you've specified.
Select a module for your custom view
To select a module for your custom view:
Select Configure grid on a new worksheet, or Select view on an existing worksheet. Alternatively, create and configure a new grid or KPI card.
The Select data source dialog opens in the Select primary grid or Card configuration panel, depending on whether you're designing a view for a worksheet or card.
Select the Custom views tab.
Select a module.
A toolbar displays in the top-right of the preview, next to any context selectors.
Select values on which to base your formatting
To select values on which to base your formatting:
Select the line item to configure conditional formatting.
Select Conditional formatting.
On the grid, select the context selector value, row heading, or column heading containing the line item to apply conditional formatting to.
Alternatively, select the line item from the Line item dropdown in the Conditional formatting panel.
In the Value dropdown, select the line item that contains the values to base the conditional formatting on.
The default is the line item you selected in the grid.
Set formatting style and conditions
To set formatting style and conditions:
In the Style dropdown, select the formatting style to apply to your conditional formatting:
Background fills the background of each formatted cell with a solid color.
Border adds a colored border to each formatted cell. This makes sure that cell values remain easy to read.
Morse adds a colored dot or dash to the left of the cell's value. The size of the dot or dash depends on the cell value.
The Color Range bar displays a sample gradient of your current selection. As you select values and colors below, the gradient bar changes to match your selections.
Beneath the Minimum heading, enter the lowest value for your conditional formatting in the Enter lowest value... field. Then select Select a color and select a color.
Optionally, add Midpoint (optional) headings. The first midpoint input field is visible. Select the plus sign to add more midpoints. For each midpoint, enter the value for your conditional formatting in the Enter a value... field. Then select Select a color and select a color.
You can remove midpoint values by selecting the minus sign above the value's color swatch.
Beneath the Maximum heading, enter the highest value for your conditional formatting in the Enter highest value... field. Then select Select a color and select a color.
Conditional formatting applies to your view, based upon your selections.
To make a further change, select Back and modify the custom view.
Select Update to apply your conditional formatting.
Your page displays in designer mode with the formatting you've configured.