View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
dk dk is offline
external usenet poster
 
Posts: 129
Default Can I lock formatting in Excel while keeping the ability to edit?

In Excel 2003, I have some conditionally formatted cells. When others use
the spreadsheet, they sometimes copy/paste information from other workbooks
to those cells, which of course eliminates the formatting I have set up. I
don't care if they copy/paste, but I need the conditional formatting to be
maintained.