Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
protect conditional formatting
Hi,
Is there a way to protect the conditional formatting (CF) and data validation (DV) rules and still allow the user to copy & paste to it without losing the CF & DV rules? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
protect conditional formatting
If you allow copy/paste then the format of the copied cell will
overwrite any formats established in the destination cell. Could you teach your users to use paste special | values instead? That way the formats will not be overwritten. Hope this helps. Pete On Oct 24, 1:06*am, GD wrote: Hi, Is there a way to protect the conditional formatting (CF) and data validation (DV) rules and still allow the user to copy & paste to it without losing the CF & DV rules? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
protect conditional formatting
Hi Pete,
The data validation is lost when you do paste values. I trying to find out if there's a way of not losing both the conditional formatting and data validation rules when the user do a copy paste even if it is paste values. "Pete_UK" wrote: If you allow copy/paste then the format of the copied cell will overwrite any formats established in the destination cell. Could you teach your users to use paste special | values instead? That way the formats will not be overwritten. Hope this helps. Pete On Oct 24, 1:06 am, GD wrote: Hi, Is there a way to protect the conditional formatting (CF) and data validation (DV) rules and still allow the user to copy & paste to it without losing the CF & DV rules? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protect the formatting | Excel Discussion (Misc queries) | |||
Use of CELL("protect") in conditional formatting in Excel 07 | Excel Worksheet Functions | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
How do I protect formatting only? | Excel Discussion (Misc queries) | |||
protect formatting | Excel Discussion (Misc queries) |