Copy means Copy and that's what the Copy function does. There are over
thirty different formats that will get copied over; colour, bold, data
validation, etc, etc, including Format conditions. If you don't want the
formats use PasteSpecial. If you want everything except CF's delete them
after, either manually or with a simple macro (though you'll lose undo)

Selection.FormatConditions.Delete

Regards,
Peter T



"Henk" wrote in message
...
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.