| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
formating cells from IF statement
I don't believe you can protect just one cell the way you described. You
have to protect the entire sheet and then unlock those cells that you want to allow editing in. "Anner" wrote: I want to protect a given cell if the contents of another cell is "Conf". I can record a macro to Format-Cell-Protection-Locked, but how do I combine that with the conditional IF? Thanks very much! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formating Cells | Excel Discussion (Misc queries) | |||
| conditional formating cells i Excel based on other cells values | Excel Worksheet Functions | |||
| Conditional formating on if statement | Excel Worksheet Functions | |||
| Flat File formating with Print# Statement | Excel Programming | |||
| formating a cell with a conditional if statement | Excel Programming | |||
Hybrid Mode
