EXCEL: Protect a cell depending on another cell value
 

Hello

I need a formula to protect a specific cell depending on the value of
another cell. For example, if(A2=0, protect(A3), "")
If A2=0, I do not want anyone to be able to modify in anyway A3

Thanks for your help

EXCEL: Protect a cell depending on another cell value
 

Functions only return information. They can't change an object. You need a
macro to do that.
HTH,
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


"frenchflo" wrote:

Hello

I need a formula to protect a specific cell depending on the value of
another cell. For example, if(A2=0, protect(A3), "")
If A2=0, I do not want anyone to be able to modify in anyway A3

Thanks for your help