Overwrite Excel output without deleting 'Highlight Cell Rules'

[carlosmartinezm]

Hi all!

I have a workflow performing a comparison between two tables field by field. 

The output in Excel consists in a table with multiple columns containing 'Yes' or 'No' for each field of the compared tables.

Sometimes the resulting table is quite big and it is not easy to find the No values. To solve that, I select the whole Excel Sheet and I add a 'Highlight Cells Rules' (To highlight the cell when the content of the cell is equal to No).

The question is:

Can my workflow overwrite Excel output without deleting 'Highlight Cell Rules'? 

Thanks!

[ck2019 · Accepted solution]

I'd recommend outputing to a separate tab and then having the template you using with the conditional formula built into the template sheet.

[carlosmartinezm]

Thanks!

I will have a hidden sheet where Alteryx loads the output data, and the official sheet with the rules and mapped data from the other sheet.

😄