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

Thread: document conditional formatting rules

  1. #1
    New Member argeedblu's Avatar
    Join Date
    Sep 2003
    Location
    Canada
    Posts
    29
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Question document conditional formatting rules

    I've posted this question on UtterAccess.com but would like to expose it to the Excel oriented community.

    My immediate issue is dealing with conditional formatting rules and being able to view more than one rule at a time. I have a set of several rules that control the appearance of a cell. It is difficult to debub logical errors in the rules without being able to compare them. On a broader, more general basis, it would be nice to print all the rules that affect certain cells.

    Is there any hope or am I chasing my tail?

    Glenn

  2. #2
    Board Regular etaf's Avatar
    Join Date
    Oct 2012
    Location
    UK, West Sussex
    Posts
    3,156
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: document conditional formatting rules

    i copy into selerate columns and view from there,so i can see how they return false true , and can help decide what order to put the rules in and also using "stop if true"
    Wayne

    Using Excel Version 365 for Mac

  3. #3
    New Member argeedblu's Avatar
    Join Date
    Sep 2003
    Location
    Canada
    Posts
    29
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: document conditional formatting rules

    Quote Originally Posted by etaf View Post
    i copy into selerate columns and view from there,so i can see how they return false true , and can help decide what order to put the rules in and also using "stop if true"
    Thanks Wayne,

    I'm actually looking for something to make the rules available as a teaching tool.

    Glenn

  4. #4
    Board Regular
    Join Date
    Jan 2014
    Location
    Pittsburgh
    Posts
    1,072
    Post Thanks / Like
    Mentioned
    10 Post(s)
    Tagged
    1 Thread(s)

    Default Re: document conditional formatting rules

    I'll never invest the time in VBA to become good with it, but I'm reasonably good with Google searches: "excel print all conditional formatting rules" [without the double-quotes]. I think these might help you.

    Daily Dose of Excel, April 2010:
    http://dailydoseofexcel.com/archives/2010/04/16/listing-format-conditions/

    VBA Express, May 2014, modifies the code from Daily Dose:
    http://www.vbaexpress.com/forum/show...et-or-Workbook

  5. #5
    Board Regular FDibbins's Avatar
    Join Date
    Feb 2013
    Location
    Duncansville, PA USA
    Posts
    6,722
    Post Thanks / Like
    Mentioned
    7 Post(s)
    Tagged
    0 Thread(s)

    Default Re: document conditional formatting rules

    I often create my CF rules IN the worksheet itself. This allows for easier editing. Just formulate them to return either TRUE or fALSE

    Plus, doing it that way would simplify "texting" the formulas so you can print them

    - Posting guidelines, forum rules and terms of use

    - Try searching for your answer first, see how

    - Read the FAQs

    - List of BB codes


    Regards

    Ford

  6. #6
    New Member argeedblu's Avatar
    Join Date
    Sep 2003
    Location
    Canada
    Posts
    29
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: document conditional formatting rules

    Quote Originally Posted by thisoldman View Post
    I'll never invest the time in VBA to become good with it, but I'm reasonably good with Google searches: "excel print all conditional formatting rules" [without the double-quotes]. I think these might help you.

    Daily Dose of Excel, April 2010:
    Listing Format Conditions | Daily Dose of Excel
    VBA Express, May 2014, modifies the code from Daily Dose:
    [SOLVED] Listing Conditional Formatting on Separate Sheet or Workbook
    Many thanks for those links. I had planned to work on a VBA solution as soon as I could find some time for coding. If this code isn't exactly what I need, it is still going to give me a great start.

    Thanks again,

    Glenn

  7. #7
    New Member argeedblu's Avatar
    Join Date
    Sep 2003
    Location
    Canada
    Posts
    29
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: document conditional formatting rules

    Quote Originally Posted by FDibbins View Post
    I often create my CF rules IN the worksheet itself. This allows for easier editing. Just formulate them to return either TRUE or fALSE

    Plus, doing it that way would simplify "texting" the formulas so you can print them
    Ford, that's a great tip. Thanks,

    Glenn

Some videos you may like

User Tag List

Tags for this Thread

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
  •