AnsweredAssumed Answered

How to keep conditional formatting when exporting to Excel?

Question asked by jamesg on Apr 28, 2015
Latest reply on May 11, 2015 by beverly

Hi All


I have been trying to export to Excel a found set of records from a layout which uses conditional formatting on certain fields whilst retaining the conditional formatting in the output spreadsheet.


I think it's not possible; I check the 'Apply current layout's data formatting to exported data' check box in the Export dialog.


If I can achieve this the intention is to import the spreadsheet as formatted into InDesign as formatted.


I don't want to use plug-ins and I have next to no understanding of XML and XSL, nor do my end users who need to be able to simply re-link the spreadsheet into their InDesign template.


Thanks for your input, I've been scratching at this for days!!