Excel File Formats, Conditional Formatting, Macro Codes = Help!
Posted on 2013-01-18
Ok, please bare with me as I explain this one... :)
I am using Excel 2010 (Mac), when I created my spreadsheet the default extension is .xlsx
When I add macro's into my workbook, I am forced into saving in another format.
Which I did, choosing the 2004-2007 version (not exactly sure what it said...)
So now the extension reads, .xls
I then add conditional formatting into my spreadsheet. When I save the workbook, it says there may be features that might be removed if saved in the current format.
I assume my problem is this,...
.xlsx is the latest format from Excel (supports 2010 or later)
.xls is the previous format from Excel
.xlsx doesn't support the use of macro's
and the conditional formatting I want, isn't supported on the older format?
I am soooo confused.
What gives? What are my options? :)
Thank you in advance for your help!