VBA Conditional formatting

  • Thread starter Thread starter Steven E.
  • Start date Start date
S

Steven E.

I can change the conditional formats of cells with the
FormatConditions Object. But is it possible to get the conditional
formats from a cell in Excel to show them in VBA?
 
? activeCell.FormatConditions(1).Formula1
5000
? activeCell.FormatConditions(1).Formula1
5000
? activeCell.FormatConditions(1).Operator
1

But See Chip Pearson's page on Conditional Formatting Colors

The code there will show you how to interpret the formulas.

http://www.cpearson.com/excel/CFColors.htm
 
You must log in or register to reply here.

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

Excel VBA 1
Delete Method as it applies to format Condition object 3
Conditional Formatting 5
Conditional formatting puzzle 2
Conditional Formatting from VBA 10
recognizing conditional formatting with VBA 3
ConditionalFormatting help 1
Delete single conditional format 3

Back
Top