Automatic Merging of Duplicate Conditional Formats in Reports

If the same conditional format definition is created multiple times, the duplicate conditional formats are now merged into single conditional formats when the report is saved and reopened. All cell references for the duplicate formats will be adjusted. Upon editing the saved report, a warning message similar to the following will be displayed: “Removed duplicate formatting rules from ‘Grid 1’. Cell references for the duplicate formats have been adjusted.”

Also, upon migration of a Financial Reporting (FR) report that contains the same conditional formatting definition applied to multiple cells, the duplicate conditional formats will be migrated and merged into single conditional formats in Reports.

Applies to: Planning and Budgeting, Close Management and Consolidation, Narrative Reporting, Profitability and Cost Management, FreeForm, Tax Reporting

Business Benefit: This feature allows for easier management of conditional formatting definitions by reducing the number of definitions due to duplicates.

Key Resources

• Designing with Reports
  • Differences between Financial Reporting and Reports
  • Creating a Condition