Return
-
Title
How to place conditional formatting in Excel after Automation script? -
Description
How to place conditional formatting in Excel after Automation script?
Creating an Automation script that generates a report from a dataset and then placing color coding conditional formatting on the Excel file gets overwritten and all conditional formatting is lost.
-
Resolution
Create an Excel file that enables Macros and save it as a macro-enabled Excel file (.xlsm) and reference it in the automation script by generating an export template.
See SOL75429: How can I use a macro in an export to Excel Automation? for more information on how to use a macro in an export to an Excel automation.