Formatting specific excel sheets in a loop (multiple files) using continental nodes

Hi All,

I feel this is getting better and better with all your inputs.

Coming back to the requirement, there are 2 things required, format column header and conditional format Exception Aging column. So i have added 3 more nodes based on the below links in the forum (sorry for making it more complicated… :slightly_smiling_face:)

Coloring cells with the Conditional Formatter

Also i would like to explain 1 parameter, i.e., most of the times any 1 sheet either T&E Queries or P2P Queries will have data the other will be blank[only header] (only in some cases both will have data). There is no issue for column header, but for conditional format, if the data is blank, i am not sure how 7, 8 and 9th nodes will handle this.

User Wise Report test.knwf (619.2 KB)

Any suggestions on this.

Regards,
Pavan