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
 

See one way in the

microsoft.public.excel.misc

group.

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


In article <9129dafa67020@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

if condition and locking cells
 

Oops, should've been

microsoft.public.excel

In article ,
JE McGimpsey wrote:

See one way in the

microsoft.public.excel.misc