Conditional formatting issues between 2007 and 2010

[jeffreybrown]

At work we just upgraded to 2010. Now when opening previously created 2007 files with extensive conditional formatting, the file shows an error and upon opening all conditional formatting is wiped out.

Searching has not produce any answers as of yet, but is the only solution to rebuild the conditional formatting?

Has anybody else run into this?

 

[James006]

Hi Jeff,

Among the many possible hurdles, have a look at all your Named Ranges ...

HTH

 

[jeffreybrown]

Hi James,

The problem, when I open the previously created 2007 workbook in the new 2010, the conditional formats are wiped out.

 

[James006]

Hi again,

They can be many different issues ...

Have a look at Debra's recap :

Excel 2010 Conditional Formatting Nightmare | Contextures Blog


HTH