Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to make cell inaccessable using if statement?
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.misc
|
|||
|
|||
How to make cell inaccessable using if statement?
PLEASE stop posting the same question! You've got one possible solution
in another group. If that doesn't work for you, reply to that answer. In article <912a01640a238@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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to make cell inaccessable using if statement?
PLEASE! stop asking same question in multiple groups under different
subjects. You've received at least one possible solution - if that doesn't work, reply to that one, or AT LEAST say why that didn't work. Don't waste people's time if that solution works. 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 then statement... can't make it work:S | Excel Discussion (Misc queries) | |||
make tabs inaccessable? | New Users to Excel | |||
How to make a Let statement in Excel? | Excel Worksheet Functions | |||
How do I make an IF statement change cell shading | Excel Worksheet Functions | |||
How can i make this work within an IF statement: (41<=Cell<=46) | New Users to Excel |