Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    Nov 2002
    Location
    London, Gtr London, England
    Posts
    496
    Thanks
    8
    Thanked 0 Times in 0 Posts

    display conditional formatting rules

    Hi Loungers,

    Does anyone know how to display the current set of conditional formatting? I don't want to go to the cells I want a listing of all the conditional formatting rules. I am sure I have seen this somewhere in the past but cannot locate it.

    many thanks

    liz

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    I have not played with this, but the code at http://dailydoseofexcel.com/archives...at-conditions/ may be adaptable.

    Steve
    PS I beleive that code should work for XL2007 and up. FOr XL97-2003, the code at http://www.contextures.com/xlCondFormat04.html should work.
    Last edited by sdckapr; 2013-10-09 at 12:32.

  3. The Following User Says Thank You to sdckapr For This Useful Post:

    RetiredGeek (2013-10-09)

Posting Permissions

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