• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 148
  • Last Modified:

Check for conditional formatting

Folks,
Is there a way to check to see if conditional formatting is being applied to a worksheet using VBA
0
Frank Freese
Asked:
Frank Freese
1 Solution
 
nutschCommented:
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

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now