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!!