View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary L Brown Gary L Brown is offline
external usenet poster
 
Posts: 219
Default 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