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?

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?

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?

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?