In order to paint the columns of the Excel columns in the desired format with red color, type the Regex that you wrote the rules for in the Script Task activity. Assign a variable to “true” or “false” to provide control.
After this activity, determine the “true” and “false” paths with the gateway.
Submit it to the Set Cell Style activity when the process goes the “true” path. Type 255,0,0 as the fill color,
After this process, you can Write Dataset to Excel and Save the excel file.