Protect conditional formatting in destination cell

[Greg]

I have a worksheet with cells having conditional formatting to identify
entries that do not match a defined name. This all works fine, unless
someone uses cut-and-paste, which removes the conditional format. I've
protected the worksheet, but apparently, if you allow for users to enter data
in these cells (which I must), then the conditional formatting is not
protected.

I'm aware that you can use paste special (value), but is there a way to make
it impossible for a user to remove the conditional formatting, but still be
able to cut-and-paste?

 

[FSt1]

hi
the standard cut(and copy) and paste, pastes all which includes formating.
this is why we have paste special for when we want to preserve the formating
in the destination cell. i know of no way to protect the conditional
formating.
you might switch your method to data validation. this is basicilly why data
validation was introduced.

regards
FSt1

 

[Greg]

Actually, the validation function has the same flaw. If data is pasted into
the cell, the validation criteria are also overwritten, unless paste special
(value) is used.

Is there no work-arounds for this issue? I've thought about making an
adjacent cell indicate an inaccurate entry, but it seems as though you should
be able to protect the formatting of a cell from being wiped out by
copy-and-paste, while still allowing values to be pasted. Any other
thoughts? Thanks. -- Greg