topic Re: Losing Conditional Formatting When Export to Excel in QlikView https://community.qlik.com/t5/QlikView/Losing-Conditional-Formatting-When-Export-to-Excel/m-p/448934#M1153440 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Try this</P><P>1. Go to Settings/ User Preferences/Export and check "Adjust Excel Pallette to colors in export".</P><P>2. Go to Settings/ User Preferences/Printing and check "Use Chart Setting"</P><P></P><P>Hope this will help.</P><P></P><P>Best,</P><P>Yani</P></BODY></HTML> Fri, 10 May 2013 14:25:18 GMT 2013-05-10T14:25:18Z Losing Conditional Formatting When Export to Excel https://community.qlik.com/t5/QlikView/Losing-Conditional-Formatting-When-Export-to-Excel/m-p/448933#M1153438 <HTML><HEAD></HEAD><BODY><P>Hello!</P><P></P><P>I've developed a pivot table in which I've included conditional formatting to change the background color to magenta if certain criteria are satisfied.&nbsp; When I export the table to Excel, I lose the conditionally-formatted background color; it reverts to a white background.&nbsp; Is there any way in which I can retain the magenta background upon exporting the table to Excel?</P><P></P><P>Many thanks!</P></BODY></HTML> Fri, 10 May 2013 13:54:43 GMT https://community.qlik.com/t5/QlikView/Losing-Conditional-Formatting-When-Export-to-Excel/m-p/448933#M1153438 2013-05-10T13:54:43Z Re: Losing Conditional Formatting When Export to Excel https://community.qlik.com/t5/QlikView/Losing-Conditional-Formatting-When-Export-to-Excel/m-p/448934#M1153440 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Try this</P><P>1. Go to Settings/ User Preferences/Export and check "Adjust Excel Pallette to colors in export".</P><P>2. Go to Settings/ User Preferences/Printing and check "Use Chart Setting"</P><P></P><P>Hope this will help.</P><P></P><P>Best,</P><P>Yani</P></BODY></HTML> Fri, 10 May 2013 14:25:18 GMT https://community.qlik.com/t5/QlikView/Losing-Conditional-Formatting-When-Export-to-Excel/m-p/448934#M1153440 2013-05-10T14:25:18Z