Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Protect conditional formatting in destination cell
hi
the standard cut(and copy) and paste, pastes all which includes formating. this is why we have paste special for when we want to preserve the formating in the destination cell. i know of no way to protect the conditional formating. you might switch your method to data validation. this is basicilly why data validation was introduced. regards FSt1 "Greg" wrote: 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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Protect conditional formatting in destination cell
Actually, the validation function has the same flaw. If data is pasted into
the cell, the validation criteria are also overwritten, unless paste special (value) is used. Is there no work-arounds for this issue? I've thought about making an adjacent cell indicate an inaccurate entry, but it seems as though you should be able to protect the formatting of a cell from being wiped out by copy-and-paste, while still allowing values to be pasted. Any other thoughts? Thanks. -- Greg "FSt1" wrote: hi the standard cut(and copy) and paste, pastes all which includes formating. this is why we have paste special for when we want to preserve the formating in the destination cell. i know of no way to protect the conditional formating. you might switch your method to data validation. this is basicilly why data validation was introduced. regards FSt1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
protect conditional formatting | Excel Discussion (Misc queries) | |||
Use of CELL("protect") in conditional formatting in Excel 07 | Excel Worksheet Functions | |||
change date formatting in destination cell | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
Protect Cell Formatting | Excel Worksheet Functions |