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 Conditional Formatting (Group) window is displayed.

   

3. To add a new Rule, click .

   Note

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

   The only additional option is Allow Row Expansion: This option must be selected to be able 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.

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