How to check if cell has conditional formatting

  • Thread starter Thread starter John
  • Start date Start date
J

John

Is there a way to check if the active cell has any conditional
formatting?
 
Is there a way tocheckif the active cell has any conditionalformatting?
Click to expand...

Sorry....looks like this might work:
If range("A1").FormatConditions.Count >0
 
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 and VBA 4
Apply Conditional formatting if cell contains formula 6
Excel Highlighting duplicates 0
Conditional Formatting with VBA 4
Excel Conditional Formatting 1
recognizing conditional formatting with VBA 3
Change Format of Active Cell 15
Conditional format if difference in cell values greater than 0.50% 1

Back
Top