https://community.qlik.com/t5/Qlik-Automate/How-can-I-apply-conditional-formatting-to-an-Excel-Automation/m-p/1998695#M1003 <P>Hi everybody.&nbsp;</P> <P>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&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="pacoarandiga_0-1667231405043.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/92528iC947A1F87C332DFA/image-size/medium?v=v2&amp;px=400" role="button" title="pacoarandiga_0-1667231405043.png" alt="pacoarandiga_0-1667231405043.png" /></span></P> <P>But when I insert the table and the rows, it looks like the condition applies only to the rows that are outside the table</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="pacoarandiga_1-1667231569313.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/92529i7B4594BC57F7F0BE/image-size/medium?v=v2&amp;px=400" role="button" title="pacoarandiga_1-1667231569313.png" alt="pacoarandiga_1-1667231569313.png" /></span></P> <P>Does anybody know how to fix that problem? Or other solution for changing the cells format?</P> <P>Thanks in advance!&nbsp;<span class="lia-unicode-emoji" title=":grinning_face:">😀</span></P> <P>&nbsp;</P> <P>&nbsp;</P> Mon, 31 Oct 2022 15:56:48 GMT pacoarandiga 2022-10-31T15:56:48Z https://community.qlik.com/t5/Qlik-Automate/How-can-I-apply-conditional-formatting-to-an-Excel-Automation/m-p/1998695#M1003 <P>Hi everybody.&nbsp;</P> <P>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&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="pacoarandiga_0-1667231405043.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/92528iC947A1F87C332DFA/image-size/medium?v=v2&amp;px=400" role="button" title="pacoarandiga_0-1667231405043.png" alt="pacoarandiga_0-1667231405043.png" /></span></P> <P>But when I insert the table and the rows, it looks like the condition applies only to the rows that are outside the table</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="pacoarandiga_1-1667231569313.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/92529i7B4594BC57F7F0BE/image-size/medium?v=v2&amp;px=400" role="button" title="pacoarandiga_1-1667231569313.png" alt="pacoarandiga_1-1667231569313.png" /></span></P> <P>Does anybody know how to fix that problem? Or other solution for changing the cells format?</P> <P>Thanks in advance!&nbsp;<span class="lia-unicode-emoji" title=":grinning_face:">😀</span></P> <P>&nbsp;</P> <P>&nbsp;</P> Mon, 31 Oct 2022 15:56:48 GMT https://community.qlik.com/t5/Qlik-Automate/How-can-I-apply-conditional-formatting-to-an-Excel-Automation/m-p/1998695#M1003 pacoarandiga 2022-10-31T15:56:48Z