Applying Conditional Formatting to a Group

The Group Formatting feature sets formatting on the group column(s) by testing a condition in comparison with the Group Code or the content of another column.

  1. In the Settings menu (right panel), click .
  2. Under the General section, click Group Formatting. The Column Formatting (Group) window is displayed.
    Note

    The Column Formatting (Group) window is similar to the Column Formatting window for columns; refer to Applying Conditional Formatting to a Column for more details.

    The only additional option is Allow Group Expand: If this checkbox is unticked, it is not possible to drill down into the group.

    Tip

    Preventing a group drill-down is useful when the details of some calculations (e.g. the transactions in a specific GL account of the income statement) should remain hidden.

  3. Click OK in each window to save the changes.