Formatting Best Practices

There are several things to keep in mind when formatting a report.

• Cell formatting has precedence over row and column formatting and grid formatting.

• Cell formatting allows you to make exceptions to row and column formatting and grid formatting.

• Row/column formatting has precedence over grid formatting.

• Row/column formatting allows you to make exceptions to grid formatting.

• Conditional formatting takes precedence over all other formatting and replaces formatting previously set at the grid, row and column, or cell level. For example, if you use conditional formatting to change cell colors, and want to retain a specific number of decimal places applied with regular formatting, you must specify both formats using conditional formatting.

• The correct sequence in formatting a report is:

  1. Format the grid.

  2. Apply different formatting to rows and columns.

  3. Apply specific cell formatting.