Evaluating Conditional Formats

G

Guest

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to copy the new Excel 2007 conditional formats 4
Excel Conditional Formatting 1
Inconsistent behavior when applying conditional formats 3
Delete Method as it applies to format Condition object 3
conditional formatting suddenly disabled 1
Delete single conditional format 3
Conditional Formatting 1
Conditional Formatting 5

Top