Locking Cell

[Ridhi]

I am trying to creat a form where in our clients need to entre detials.I am
trying to provided two options out of which one has to selected by the
client.on selecting one option the other optional cells should get
deactivated or lock so that no value can be entred in the other optional
Cell..

Is there any way to do this....

 

[sb1920alk]

If you really want to "lock" it, you'll have to use a macro.

Depending on how formal you want to be, you could use conditional formatting
to make it match it's background color if the first cell is not blank. Or do
it the other way around so the optional cells normally have the same font
color as the background color, but when the first option is entered, the
conditional formatting "activates" them by changing the font color.