How to protect formatting

D

Dr. Schwartz

I have a sheet with cells containing conditional formatting. The user of the
sheet is supposed to paste data. If data is pasted normally (Ctrl+V) then
formatting is gone. If paste special values is used then it works fine.
However I need to ensure that paste special values is used. Is it possible to
lock the formatting of cells in som way?

Any other ideas how to solve this problem?

Thank you
The Doctor
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

... I would like to link conditional formating to linked workbooks 2
Pasting into a cell with conditional formatting 1
Conditional formatting overwritten with copy 3
protect conditional formatting 2
Formatting not protected when paste 7
Conditional Formatting option not available 6
How can I protect cell formatting but allow users to enter data? 2
Paste Special Formats Generated by Conditional Formatting 6

Top