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

Thread: Conditional Formatting Rules Manager....

  1. #1
    Board Regular
    Join Date
    Dec 2009
    Location
    Canterbury, UK
    Posts
    3,370
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Angry Conditional Formatting Rules Manager....

    ..... makes me want to kill myself.


  2. #2
    Moderator mole999's Avatar
    Join Date
    Oct 2004
    Location
    UK
    Posts
    9,370
    Post Thanks / Like
    Mentioned
    14 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Conditional Formatting Rules Manager....

    care to explain, its better options than we had in 2003
    • Yes I know there are better ways to do it. I just wish I knew them. - 2003, 2007, 2010, 2013 & 2016
    • I wear my ignorance openly, excel is not my chosen career, its a means to an ends
    • Posting Guidelines Want to post well laid out questions and answers Translate Excel Versions
      Code:
      [CODE ]Put Your Code[/ CODE]
    • Settings > General Settings (on the left) scroll to the bottom, > Miscellaneous Options > Use ENHANCED
    • X-Posting Guidelines Rule 13 > CHART STUFF

  3. #3
    Board Regular
    Join Date
    Dec 2009
    Location
    Canterbury, UK
    Posts
    3,370
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Conditional Formatting Rules Manager....

    Quote Originally Posted by mole999 View Post
    care to explain, its better options than we had in 2003
    Excel 2010.

    I haven't quite figured out how it happens but a rule will get split into multiple rules.

    So I've been deleting them all and reinstating the initial rule with a continuous range.

    Deleting rules from the window involves deleting them one by one.

    I have since written a Sub that will delete all rules and re-create on workbook save.

  4. #4
    Moderator mole999's Avatar
    Join Date
    Oct 2004
    Location
    UK
    Posts
    9,370
    Post Thanks / Like
    Mentioned
    14 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Conditional Formatting Rules Manager....

    I know that one, cut / copy / paste does wonders for reordering everytime
    • Yes I know there are better ways to do it. I just wish I knew them. - 2003, 2007, 2010, 2013 & 2016
    • I wear my ignorance openly, excel is not my chosen career, its a means to an ends
    • Posting Guidelines Want to post well laid out questions and answers Translate Excel Versions
      Code:
      [CODE ]Put Your Code[/ CODE]
    • Settings > General Settings (on the left) scroll to the bottom, > Miscellaneous Options > Use ENHANCED
    • X-Posting Guidelines Rule 13 > CHART STUFF

  5. #5
    Board Regular TinaP's Avatar
    Join Date
    Jan 2005
    Location
    Ohio
    Posts
    519
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Conditional Formatting Rules Manager....

    Quote Originally Posted by Comfy View Post
    I haven't quite figured out how it happens but a rule will get split into multiple rules.
    It happens when cells are added/deleted within the original range. Pain in the rear, I agree.

    I've found this link extremely helpful: Daily Dose of Excel Blog Archive Easy way to back up CF formats
    I not only use all the brains that I have, but all that I can borrow. --Woodrow Wilson

  6. #6
    Moderator mole999's Avatar
    Join Date
    Oct 2004
    Location
    UK
    Posts
    9,370
    Post Thanks / Like
    Mentioned
    14 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Conditional Formatting Rules Manager....

    i deal with it when I have finished building the file and understand the rules, then create them fresh
    • Yes I know there are better ways to do it. I just wish I knew them. - 2003, 2007, 2010, 2013 & 2016
    • I wear my ignorance openly, excel is not my chosen career, its a means to an ends
    • Posting Guidelines Want to post well laid out questions and answers Translate Excel Versions
      Code:
      [CODE ]Put Your Code[/ CODE]
    • Settings > General Settings (on the left) scroll to the bottom, > Miscellaneous Options > Use ENHANCED
    • X-Posting Guidelines Rule 13 > CHART STUFF

Some videos you may like

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
  •