Cell formatting has precedence over row/column formatting and grid formatting. Cell formatting allows you to make exceptions to row/column formatting and grid formatting. Row/column formatting has precedence over grid formatting. Row/column formatting allows you to make exceptions to grid formatting. Therefore, the correct sequence in formatting a report is to first format the grid, then apply different formatting to rows/columns, then apply specific cell formatting.
Conditional formatting takes precedence over all other formatting and replaces formatting previously set at the grid, row/column, or cell level. For example, if you use conditional formatting to change cell colors, yet want to retain a specific number of decimal places applied with regular formatting, you must specify both formats using conditional formatting. |