How can I apply conditional formatting to an Excel Automation report?

[pacoarandiga]

Hi everybody. 

I'm trying to put colors on my Excel report. Fort that, I used conditional formatting in Nprinting and it worked perfectly. Now I'm trying to do the same on Qlik Application Automation. I put the conditions on my Excel template for all the columns of the table 

But when I insert the table and the rows, it looks like the condition applies only to the rows that are outside the table

Does anybody know how to fix that problem? Or other solution for changing the cells format?

Thanks in advance! 😀