• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

lock n unlock cells

rrocker1405

Member
Not sure how to do this.

[pre]
Code:
Columns
A            B        C         D      E       F        G         H
[Blank]   [Blank]   Header   Months   Date   units   update   Comments
[/pre]
The form should do this.

1. User should be able to select month from the drop-down (I've already placed content)

2. Based on the month selected the entire dates will populate (I already have a formula to generate)

3. Users should be allowed to enter units btwn 1 and 10, if the entry is 10 details in column g and column H should be locked for entry, else unlock columns G and Column H for entry only when units is less than 10 and also to populate msgbox 'your units produced is less than 10, please provide details'


Thanks in advance...

Best regards


not sure how to protect and unprotect.
 
Select cols G and H. Under Data Validation, setup a custom rule of:

=F2<>10


This will make it so that the user can input into these cells unless F2 is 10. Rather than displaying a msgbox, might I recommend just using conditional format? You could make G & H become yellow or something via:

=AND(COUNTBLANK(G2:H2)=2,F2<10)
 
Back
Top