protecting cell depending on value of another cell



I tend to limit data entry on my worksheets by unchecking the "Lock" box
(Format Cells -> Protection -> then uncheck lock box) and then protecting the
sheet (Tools -> Protection -> Protect Sheet) with only "Select unlocked
cells" checked.

I am creating a worksheet where some of the cells require entry only if
there is a certain value in a certain cell. For example:

if J3="BLING" ... then Q13 is locked

if J3="CLATTER" ... then Q13 is unlocked

Is it possible to lock or unlock a cell automatically according to the value
of one of the cells on a worksheet?

Thanks in advance,

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