Check for conditional formatting

Folks,
Is there a way to check to see if conditional formatting is being applied to a worksheet using VBA
Frank FreeseAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
nutschConnect With a Mentor Commented:
This code will tell you if there's some conditional formatting, not what or where it is on the sheet:
Sub testformat()

If ActiveSheet.Cells.FormatConditions.Count > 0 Then
    MsgBox "conditional formatting"
Else
    MsgBox "nope"
End If
End Sub

Open in new window

0
 
Frank FreeseAuthor Commented:
that nailed it
thank you
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.