Protect conditional formatting in destination cell

  • Thread starter Thread starter Greg
  • Start date Start date
G

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?
 
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
 
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
 
Back
Top