If you allow copy/paste then the format of the copied cell will
overwrite any formats established in the destination cell. Could you
teach your users to use paste special | values instead? That way the
formats will not be overwritten.

Hope this helps.

Pete

On Oct 24, 1:06*am, GD wrote:
Hi,
Is there a way to protect the conditional formatting (CF) and data
validation (DV) rules and still allow the user to copy & paste to it without
losing the CF & DV rules?