On Jul 28, 9:46*am, Jim Thomlinson <James_Thomlin...@owfg-Re-Move-
This-.com wrote:
While you can not protect the cells with a formula you could use custom data
validation to make inputs invalid in cells B1:B10 meaning that they are
protected from change.

Select the Range B1:B10
Click Data - Validation... -Custom
=$A$1<500
Uncheck Ignore Blanks
You can change the error alert.
Click OK

If 500 is entered in Cell A1 then B1:B10 can not be modified.
--
HTH...

Jim Thomlinson



"John Sofillas" wrote:
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!- Hide quoted text -

- Show quoted text -

THANK YOU!! This is exactly the info I was looking for. However, I am
still able to overwrite the fields in the range. Here is exactly what
I need to do/what I did. Please advise where I messed up. Thanks!

Selected Range
Clicked Data - Validation... -Custom
Formula =$M$11<=$M$14
Unchecked Ignore Blanks
Checked apply these changes to all other cells
Typed in my message and subject
Did nothing to Error Alert tab

???