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.
- In the Settings menu (right panel), click
.
- 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.
TipPreventing 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.
-
Click OK in each window to save the changes.