Lock Cell Depend on List selection

[vinaynaran]

Dear all,

Please see attached file. (I have explained what I want)

Actually I want to be a cell lock depend on list Selection.

If B1=”Zero Hours” then Cell(B2) Must be locked and cell B3 should open to enter amount.
If B1=”Full Times” or “Part Time” then Cell(B2) Must be open to enter Amount and cell B3 should lock.

Pease help me.




Thanks
Vinay

[Fotis1991]

Hi

You can use Custom Validation for this.

In Custom validation.

For B2 >>> =B1<>”Zero Hours”)

For B3>>> =AND(B1<>”Full Times”;B1<>“Part Time”)

Hope, that help you..

[vinaynaran]

Thanks Fotis,

It's working perfect. so nice of you.

Vinay

[Fotis1991]

You are welcome, Vinay!

Would you pls, mark your Thread, as Solved?