Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |