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:

[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.

[dreldrel]

Hi @Raj , thank you for replying to me. Would you mind sharing more ideas on using blob tools to achieve this?