Hello Dear Excel Masters
The thing which bothers me is: How do I remove or reference particular formating?
a)
I can not use index to access particular item of FormatConditions collection, because the position in collection is volatile.
b)
I can not filter FormatConditions collection by address of .AppliesTo.Address because more than 1 condition can apply to same range.
c) I can not use named range because it is translated in FormatConditions to range.
Here is example:
I create a named range like this:
How do I remove the condtion such that other conditions stay?
Following code removes all conditions.
Edit:
Ah I see I have to filter both by AppliesTo.Address and by expresion.
The conditional formating i such a pain. I dont like it but it is much faster than applying formats stored in arrays.
Bookmarks