Excel conditional formatting is lost

Conditional formatting gets removed from the Excel 2007 & 2010 files after manipulated by some of the instructions.

Why does this happen?

This is a limitation of the underlying technology components used to manipulate 2007 and 2010 data. Because Excel does not store conditional fomratting instructions in the standards based methods for 2007 and 2010, the formatting instructions are not correctly identified and retained.

How to fix this

Save Excel file as 2003 (*.xls) format and then try to run instructions again.

Leave a Reply

Latest Tweets

Free eBook: 10 Tips for sourcing good data yucalc.com/2017/02/17/fre…

reply · retweet · favorite


By signing up, you agree to our Terms of Service and Privacy Policy.


Suite 1506, Westfield Tower 2, 101 Grafton St Bondi Junction NSW 2022 Australia

View Larger Map

Contact Us

AUS: +61-2-9386-0202
UK: +44-20-8123-1251
Send us an email

WordPress Image Lightbox