Excel Output: Show Formulas and Results with Conditional Formatting

dreldrel

Hi there,

I'm trying to apply conditional formatting to columns. With the output data tool, the output file displays the final results and the formula when I click on a cell. However, when I use the render tool, it only shows the formula.

Is there a way to achieve the same result with the render tool? I'm open to using other tools as long as conditional formatting can be applied. Thank you in advance.

Output Tool:

Render Tool:

Sample Workflow.yxmd

Raj

@dreldrel 
when you use render tool you need to first convert your data into table using table tool and when you write it to excel this will stay in table format
so as per my knowledge there is no possible way to achieve this using render tool

if the table is always in same format i suggest an alternative of blob tool
hope this helps.