EXCEL: Protect a cell depending on another cell value

F

frenchflo

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
 
G

Gary L Brown

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