View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Greg Greg is offline
external usenet poster
 
Posts: 331
Default Protect conditional formatting in destination cell

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?