Identify specific formatting conditions with VBA

[Greemo]

Hello,

In my spreadsheet I have a variation of conditional formatting rules applied (that often overlap each other) to specific cells. Sometimes I have an icon set applied on top of another conditional formatting rule that simply turns the font color red if the value is greater than my specified value. How do I have a sub to detect whenvthere is an icon set, to delete that icon set rule and keep any other additional conditional formatting rules I may already have applied?

I currently have this which deletes all of the conditional formatting rule instead of just the icon set conditional formatting rule:

If Selection.FormatConditions.Count > 0 Then
Selection.FormatConditions.Delete

 

[Greemo]

Bump - any help on this?

Thanks,

Greemo

 

[Greemo]

Bump -

To clarify: I'm looking to delete only specific formatting conditions while still preserving any other formatting conditions that may be applied. E.g. I want to check if there is an existing icon set conditional formatting rule, if so then to delete this specific rule only and no others.

Any help would be appreciated.

Thank you,

Greemo

 

[marcucciboy2]

Sounds like the easiest way would be to change the conditions on the one that you sometimes will delete. I would probably make it something like this

=AND( originalCondition, Not( cancellingCondition ))