I have multiple excel files and each file has 3 sheets, i would like to format the heading and conditional format 1 column for last 2 sheets using continental nodes. Example as shown below:
I have searched in the forum and found some useful info and was able to build workflow to some extent.
I am somehow missing from which node output should i be connecting to the continental nodes for formatting and how do i write it back to the excel. All this process with in the loop, so that formatting happens along side of file creation. Attached are the workflow and sample data for quick reference.
Any thoughts on this?