Conditional format disaster in 2007
When you copy paste a cell with conditional formatting to another cell with
conditional formatting, the conditional formatting is added to the new
location. Who the **** did invented that?? Anyone any idea how to switch that
off and overwrite the existing format as it used to do (and ought to do, I
think).
Something like Application.OverwriteConditionalFormatting = True would be
nice.
Nobody ran into this problem yet?? I have an enormous lot of code using the
old fashioned overwrite way. Any thoughts and comments about this?
Thanks.
|