Format an entire field based on field description in metadata

[KimLamNg]

My goal is to format certain columns in an excel output generated by reporting tools. It needs to be dynamic because the number of columns in the ouptut can vary depending on in the input file. Ideally, I want to embed the criterion as metadata. For example, if a column is tagged "Formatted" in the description, the entire column should be highlighted in yellow. Alternatively, the criterion can be a row in the output. 

Please let me know if this is possible in Alteryx or if there are any workarounds?

Thank you.

[apathetichell]

Hey --- there are some online trainings on how to use the table tool (and subsequently the render tool) in the online training. That can guide you in how to do this. So the short is --- yes. if you use the Table tool and Render. That means 1) you can only create the file one time in the worklow (one Render, all sheets) --- the tool will overwrite any existing any file with the same name.

[Qiu]

@KimLamNg 
It is better to have a sample input and desired output for us to better understand your question.

[caltang]

Sounds like something the Reporting tool can do. What do you have in mind? Give us some data to work with and an expected output... then we can better advise.

[KimLamNg · Accepted solution]

Thanks everyone. I was able to solve the problem thanks to this post https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Highlight-cells-that-No-across...

Essentially the idea is to use a batch macro to dynamically update the xml configuration of Table tool.