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?

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

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

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