Hi. I’ve recently completed an SEO Audit course which uses spreadsheets with conditional formatting. I can do this in Calc as .xlsx, but when opening the file in Excel (as I expect many of my clients would), the conditional formatting is lost. Is there any way around this? Thanks!
For instance - highlighting duplicates, or background colour for cells containing certain text. Can do in LibreOffice but when opening in Excel get the following message:
“Excel found unreadable content in ‘.xlsx’. Do you want to recover the contents of this workbook? If you trust the workbook, click Yes.”
Click Yes, file loads, all there - except the conditional formatting.
(Same thing happens as an .ods file.)