Use Conditional formatting to color-code cells based on a predetermined set of rules.
Colors are shaded gradually between the minimum and maximum values you set. Values that exceed the maximum are given the maximum color. Values less than the minimum are given the minimum color.
To apply conditional formatting to a module:
- Open the Conditional formatting dialog box.
- In a module, select the Conditional formatting icon from the toolbar. You can also navigate to Format in the toolbar, then select Conditional formatting in the dropdown menu.
- In a dashboard, select the dropdown arrow in the top-left corner of the grid. From the dropdown menu select Format and then Conditional formatting.
- Select the New Rule button and then, select the line item you want to format, from the dropdown menu.
- From the dropdown menu, select the line item that contains the values the color-code should be based from. By default it is the same as the line item you want to format.
- Choose the values and colors. You can:
- Select a 2-color scale and set the Minimum and Maximum values.
- Select a 3-color scale and set the Minimum, Mid-point and Maximum values.
- Optional step: Change the colors you want to use from the color dropdown menu.
- Select OK to save your rule.
- Select the Enable Conditional formatting checkbox, in the bottom-right corner of the Conditional formatting dialog box.
- Select OK to apply your rule.
To remove the conditional formatting rule, deselect the checkbox to the left of the Conditional formatting icon, in the toolbar.