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.

Recent Posts

Leave a Comment