There is currently not a way to add formatting, like coloring or formulas, to an Excel file created through automation. One possible workaround is to add the formatting you want in a blank Excel file to use as a template. Once the Excel file is created through automation, copy and paste the format only from the template Excel file to the file created in automation.
