Export to Excel loses Formatting

Export to Excel loses Formatting

Hello 

I have been trying to export and share a report I have created via email as an excel attachment however this loses it's conditional formatting applied within the report. I have tried both xls and xlsx and selected the option to export "Current View (Data)"   

Thanks
Ryan