EXCEL: Protect a cell depending on another cell value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Functions only return information. They can't change an object. You need a
macro to do that.
HTH,
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel formula, sum the value cell and if empty cell left blank 0
Creating a formula relating to several cells 2
Help Creating Excel Formula 4
How to I set a limit on the value returned by a cell 3
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Formula in Excel 07 to get the formula used in one cell in anothercell, showing VALUES, not cells re 1
Calculations 1
How to protect cell with formula from being entering info 1

Back
Top