| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Conditional Cell protection
I would like to blank and protect certain cells depending on a value in one
cell (A1). If, e.g. the value in cell A1 is 6, then the users are only allowed to enter values in the first 6 weeks for that year (=first 6 columns in the table). In order to avoid problems I would like to erase all existing data in columns 7-- and then lock these cells. Any ideas how to do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Cell Shading (based on the shading of other cells) | Excel Worksheet Functions | |||
| Conditional formatiing based on another cell | Excel Discussion (Misc queries) | |||
| Conditional formatting a full row triggered by a single cell | Excel Worksheet Functions | |||
| Conditional formatting a full row triggered by a single cell reference... | Excel Worksheet Functions | |||
| conditional cell shading when a change occurs | Excel Discussion (Misc queries) | |||
Linear Mode
