Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I would like to create a workbook in Excel 2011 for Mac that is fully usable in Excel 2003 (on Windows XP, Compatibility Pack installed).

The purpose is a semi-automatic calendar, where one enters holidays in one sheet and those days are automatically highlighted (as well as weekends) in other sheets. Here are links to the 2011 version and saved as Excel 97-2004 workbook. Feel free to open them to get an idea of what I'm talking about.

enter image description here

Now the point is that according to my targeted user the conditional formatting is lost in Excel 2003. I fired up the compatibility report and it does say that there are issues.

Workbook contains conditional formatting that cannot be displayed: Earlier versions of Excel cannot display data bars, color scales, and icon sets.

But there are no data bars, color scales or icon sets. I use a formula to set the font style and that's it. That's also what Excel 2003 should be capable of. The functions used in the formula are also available in Excel 2003: INDIRECT, MOD, DATE, MONTH, IF, AND, OR, MID, CHOOSE, WEEKDAY, COUNTIF.

If I were to guess, I'd say that Excel 2011 inserts one of those things (data bars, color scales, icon sets) automatically. But then again, there are no other rules than my own. And there are only 3 of them, so that shouldn't be a problem either.

Do you have an idea what could be wrong? Could you please help me spotting the error?

Thanks in advance!

share|improve this question
    
Feel free to post a link to the image (using something like snag.gy) and someone will come along and insert it –  soandos Oct 24 '12 at 8:49
    
This is what it should look like: imgur.com/3Aap4 –  prayerslayer Oct 24 '12 at 9:56
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.