Conditional Formatting

  • Thread starter Thread starter ExcelMonkey
  • Start date Start date
E

ExcelMonkey

Is it possible to tell whether a an excel range has
conditional formatting applied to it from VBA? That is,
can I pass a range to a function which states in boolean
(true/false) whether the range is conditionally formatted?

Thanks.
 
Try:

0=Range("B1:B9").FormatConditions.Count

If TRUE, the range has conditional formatting, if FALSE, it does not
 
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

Conditional Formatting 1
Excel VBA 1
Excel Conditional Formatting Removal 7
Inconsistent behavior when applying conditional formats 3
Identifying Conditional Format 2
run a macro in excel when moving data 0
the value of a condition in a conditional format 2
Conditional Formatting in 2007 1

Back
Top