Condition formatting of the field is not working when exporting to excel

Q&A
, ,
1

I have created a calculated field which should in yellow colour when the value is less than 0 but in black colour when the value is greater than 0. it’s reflecting in the Quicksight but not when i am exporting it to excel. Please suggest

2

Hi @bhumika18s

Conditional formatting such as cell or text colors is not preserved when exporting tables or pivot tables to Excel, the exported file contains only the raw data without any of the color coding or formatting shown in the dashboard.

I will mark this as a feature request to promote visibility to the support team.

3

Hi @bhumika18s ,
I don’t think this is possible.
You can create pixel perfect reports, where you can then export pdf with the formatting you require, but direct CSV export with conditional formatting, at the moment, is not possible.

Best regards,
Andrea

4

Hi @bhumika18s

It’s been a while since we last heard from you. If you have any further questions, please let us know how we can assist you.

If we don’t hear back within the next 3 business days, we’ll proceed with close/archive this topic.

Thank you!

5

Hi @bhumika18s

Since we have not heard back from you, I’ll go ahead and close/archive this topic. However, if you have any additional questions, feel free to create a new topic in the community and link this discussion for relevant information.

Thank you!