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? |
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? |
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? |
All times are GMT +1. The time now is 12:51 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com