| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF Formula that results in Protection????
Hi,
I was wondering if there was a way to write an IF formula that results a range of cells to be protected? In other words, if A1 = 500, then B1:B10 would be protected? I also heard there may be a way to format a cell to where you could have a formula in, yet still be able to key punch in it, without having to erase the formula in the cell. This too would satisfy my needs. Any truth to it? If someone could answer either of my inquiries, I would appreciate it. Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| When I enter a formula, Excel shows the formula not the results | Excel Worksheet Functions | |||
| cell protection based on a formula | Excel Worksheet Functions | |||
| How do I view formula results intead of formula in excel? | Excel Worksheet Functions | |||
| View formula results instead of formula in 2003 version? | Excel Discussion (Misc queries) | |||
| Modifying a formula to display the results of another formula | Excel Worksheet Functions | |||
Threaded Mode
