Losing Conditional Formatting When Export to Excel

[#1]

Hello!

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.  When I export the table to Excel, I lose the conditionally-formatted background color; it reverts to a white background.  Is there any way in which I can retain the magenta background upon exporting the table to Excel?

Many thanks!

[#2]

Hi,

Try this

1. Go to Settings/ User Preferences/Export and check "Adjust Excel Pallette to colors in export".

2. Go to Settings/ User Preferences/Printing and check "Use Chart Setting"

Hope this will help.

Best,

Yani