if condition and locking cells
 

I have two columns that I am working with. Column A says "Is Employee?"....
Column B says "If Employee 'yes', enter name"

A B
Is Employee? If Employee yes, enter name.

The "is employee?" column has a drop down menu with the yes and no option. I
need a function where if column A is yes, then user can type name in column B.

HOWEVER, if a cell in column A is NO, then user cannot type anything in
adjacent cell column B. (It would be nice to have a function where if a cell
in column A is No, then cell in column B automatically gets grayed out and
becomes inaccessable.)

thanks in advance

if condition and locking cells
 

PLEASE don't post the same message in multiple groups - it just tends to
fragment your answers, and it wastes the time of those replying to
questions that have already been answered.

In article <9129d9cdfe380@uwe, "kashvii" <u49314@uwe wrote:

I have two columns that I am working with. Column A says "Is Employee?"....
Column B says "If Employee 'yes', enter name"

A B
Is Employee? If Employee yes, enter name.

The "is employee?" column has a drop down menu with the yes and no option. I
need a function where if column A is yes, then user can type name in column B.

HOWEVER, if a cell in column A is NO, then user cannot type anything in
adjacent cell column B. (It would be nice to have a function where if a cell
in column A is No, then cell in column B automatically gets grayed out and
becomes inaccessable.)

thanks in advance