Specify conditional formatting

WARNING
The legacy Report Builder is end-of-life in June 2026. As of July 1, 2026, workbooks scheduled using the legacy Report Builder will no longer be delivered.
  • You have until August 12, 2026 to migrate your workbooks from the legacy Report Builder to the new Report Builder. See convert your legacy workbooks for detailed information.
  • With the end of life of the Adobe Analytics 1.4 API’s, the legacy Report Builder add-in will no longer be available for download.
  • After August 12, 2026, customers with workbooks requiring migration will need to contact customer support to obtain the orignial workbooks. These workbooks will need to be migrated as documented in convert your legacy workbooks.
Report Builder
cloud destination for export

After you create reports with embedded requests, you can apply conditional formatting to workbook cells.

On the Report Builder Toolbar, click Format.

Conditional formatting lets you identify cells that contain results or values that you want to monitor. For example, you can apply red shading or highlighting to a particular cell if the revenue is below expectations, and blue shading if revenue exceeds amounts that you forecast. If a change in date ranges for requests removes conditions that cause conditional formatting to apply to cell values, the formats that highlight that condition are disabled temporarily. When the conditional formats you specify result in no change because conditions are not met, the conditional formats continue to apply to cells until you remove them.

For security reasons, macros are disabled if you write the workbook macros using Excel’s Visual Basic for Applications (VBA) language.

NOTE
Conditional formatting is an Excel feature. For information about creating formatting rules, see the Excel documentation.
recommendation-more-help
analytics-help-analyze