Worksheet Formatting
Worksheet formatting allows you to control how data is displayed, improving readability and making key values stand out. You can format individual columns or groups, or apply rules to highlight specific values—presenting your data clearly and effectively.
Several formatting options are available:
| Section | Description |
|---|---|
| Column Formatting | Set number formats, alignment, font style, and color for column values. |
| Column Formatting Priority | Specify which format takes precedence when more than one applies to the same column. |
| Column Conditional Formatting | Apply formatting to cells based on conditions—such as outliers or threshold values. |
| Group Formatting | Format group levels to make them distinct from detail rows. |
| Group Formatting Priority | Control which group-level format is applied when multiple rules exist. |
| Group Conditional Formatting | Use rules to highlight patterns or trends in aggregated group data. |