| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Protecting sheets
Can I protect a sheet from format changes, but still be able to change cell
color? I am using Excel 2000. |
|
#2
|
|||
|
|||
|
TV
Cell color is a format. Conditional formatting will work on any cells you have set to be "unlocked" even when the sheet is protected. Otherwise you would need to use VBA to unprotect the sheet, make the color change then re-protect. Do you want to go this route? Gord Dibben Excel MVP On Mon, 29 Nov 2004 12:39:04 -0800, "TV" wrote: Can I protect a sheet from format changes, but still be able to change cell color? I am using Excel 2000. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Two sheets | Charts and Charting in Excel | |||
| How do I plot data by drilling down through sheets? | Charts and Charting in Excel | |||
| Protecting certain cells | Charts and Charting in Excel | |||
| need an advice in excel sheets.... | Excel Discussion (Misc queries) | |||
| Formatting sheets | Excel Discussion (Misc queries) | |||
Linear Mode
