This should be simple (I would think), but not sure how to do it. If I have a single conditional format that's applied to multiple cells, how can I use VBA to remove that conditional format for JUST ONE (or maybe a few) of those cells?
The cell(s) to be changed is variable (I'll call it MyRange). I need code that handles this for any current AppliesTo range for the conditional format.
I know I could use:
MyRange.FormatConditions(1).Delete
but does that simply remove the conditional format from MyRange (leaving it intact for any remaining cells), or does it completely delete that conditional format from ALL of its cells (which is NOT what I want)?