If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How to protect a cell with conditional format?
Hi
I have a work sheet with 20rows and few hundred columns.All the cells has different values and so has different conditional format.the worksheet is protected with the required cells locked.The cells with conditional format has not locked and people unknowingly copying the cells from one to another.And this made the conditional format(values) to change.Can anyone tell me how to lock the conditional format so that even if they copy, the conditional format should not change from one cell to another.Please help. -- Ruby |
#2
|
|||
|
|||
How to protect a cell with conditional format?
1. unprotect the worksheet
2. unlock all cells 3. Edit Goto Special... Conditional formats 4. Format Cells... Protection Locked 5. protect the worksheet. -- Gary''s Student - gsnu200797 |
Thread Tools | |
Display Modes | |
|
|