conditional locked cell?

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

Guest

is there a way to have a conditional format that locks the cell?
in A1 i have a date, what i want is if(month(a1))=month(today()), then the
cell is locked, if not then it is not locked.

thank you
 
You could do it using the change event or the calculate event, but not with
conditional formatting.
 
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

Disable/enable or lock/unlock cells in VBA dependent on other cells values 2
Locking specific cells 1
Conditional Cell Lock 2
lock cells with values 2
cell locking via VBA 3
formating cells from IF statement 2
Prevent clicking on a cell 7
Programmatically setting Conditional Formatting to a range of cells 7

Back
Top