+ Reply to Thread
Results 1 to 4 of 4

Evaluating Conditional Formats

  1. #1
    Robert Mulroney
    Guest

    Evaluating Conditional Formats


    Is it possible to evaluate the result of a conditional format function? I
    want to use a macro to copy part of a worksheet "as it appears" into a new
    workbook. The problem is the conditional format formula for the cells I need
    to copy involve cells that won't be moved to the new sheet. I really need to
    strip the conditional formatting and keep the appearance.

    I know I can access the FormatConditions collection to find out what formats
    are possible but that only narrows it down one of to three possibilities. How
    can you tell which condition is being displayed?


  2. #2
    Rowan
    Guest

    Re: Evaluating Conditional Formats

    This might help:

    http://www.cpearson.com/excel/CFColors.htm

    Regards
    Rowan

    Robert Mulroney wrote:
    > Is it possible to evaluate the result of a conditional format function? I
    > want to use a macro to copy part of a worksheet "as it appears" into a new
    > workbook. The problem is the conditional format formula for the cells I need
    > to copy involve cells that won't be moved to the new sheet. I really need to
    > strip the conditional formatting and keep the appearance.
    >
    > I know I can access the FormatConditions collection to find out what formats
    > are possible but that only narrows it down one of to three possibilities. How
    > can you tell which condition is being displayed?
    >


  3. #3
    Robert Mulroney
    Guest

    Re: Evaluating Conditional Formats

    Terrific thanks for that.

    - Rm


    "Rowan" wrote:

    > This might help:
    >
    > http://www.cpearson.com/excel/CFColors.htm
    >
    > Regards
    > Rowan
    >
    > Robert Mulroney wrote:
    > > Is it possible to evaluate the result of a conditional format function? I
    > > want to use a macro to copy part of a worksheet "as it appears" into a new
    > > workbook. The problem is the conditional format formula for the cells I need
    > > to copy involve cells that won't be moved to the new sheet. I really need to
    > > strip the conditional formatting and keep the appearance.
    > >
    > > I know I can access the FormatConditions collection to find out what formats
    > > are possible but that only narrows it down one of to three possibilities. How
    > > can you tell which condition is being displayed?
    > >

    >


  4. #4
    Rowan
    Guest

    Re: Evaluating Conditional Formats

    You're welcome.

    Robert Mulroney wrote:
    > Terrific thanks for that.
    >
    > - Rm
    >
    >
    > "Rowan" wrote:
    >
    >
    >>This might help:
    >>
    >>http://www.cpearson.com/excel/CFColors.htm
    >>
    >>Regards
    >>Rowan
    >>
    >>Robert Mulroney wrote:
    >>
    >>>Is it possible to evaluate the result of a conditional format function? I
    >>>want to use a macro to copy part of a worksheet "as it appears" into a new
    >>>workbook. The problem is the conditional format formula for the cells I need
    >>>to copy involve cells that won't be moved to the new sheet. I really need to
    >>>strip the conditional formatting and keep the appearance.
    >>>
    >>>I know I can access the FormatConditions collection to find out what formats
    >>>are possible but that only narrows it down one of to three possibilities. How
    >>>can you tell which condition is being displayed?
    >>>

    >>


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1