Applying a Default Dynamic Formatting Template to the Worksheet

Procedure

Select EPM Options Sheet Options .
The Sheet Options dialog box opens.
Select the Formatting tab.
Select the Apply Dynamic Formatting option.
Select the template you want to apply to the worksheet from the Default Formatting Sheet list.
If the reports to which you want to apply dynamic formatting, already contain formatting applied by a plug-in other than the EPM plug-in, do one of the following:
- To keep the existing formatting and override it with the dynamic formatting, deselect the Clear report format before applying dynamic formatting option.
- To clear the existing format so that only the EPM dynamic formatting is applied, select the Clear report format before applying dynamic formatting option.
Click OK.

By default, the selected template applies to all reports in the worksheet.

To display the formatting on your report, refresh the report.