Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
if condition and locking cells | Excel Discussion (Misc queries) | |||
Locking cells | Excel Worksheet Functions | |||
Locking/Unlocking cells upon condition | Excel Discussion (Misc queries) | |||
locking formula in cells in without locking whole sheet | Excel Discussion (Misc queries) | |||
Locking Cells | Excel Discussion (Misc queries) |