Conditional formatting issues between 2007 and 2010

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Conditional formatting issues between 2007 and 2010

  1. #1
    Board Regular jeffreybrown's Avatar
    Join Date
    Jul 2004
    Posts
    5,121
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Conditional formatting issues between 2007 and 2010

     
    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?
    Jeff

  2. #2
    Board Regular James006's Avatar
    Join Date
    Apr 2009
    Posts
    1,710
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Conditional formatting issues between 2007 and 2010

    Hi Jeff,

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

    HTH

  3. #3
    Board Regular jeffreybrown's Avatar
    Join Date
    Jul 2004
    Posts
    5,121
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Conditional formatting issues between 2007 and 2010

    Hi James,

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

  4. #4
    Board Regular James006's Avatar
    Join Date
    Apr 2009
    Posts
    1,710
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Conditional formatting issues between 2007 and 2010

      
    Hi again,

    They can be many different issues ...

    Have a look at Debra's recap :

    Excel 2010 Conditional Formatting Nightmare | Contextures Blog


    HTH

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com