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 |
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 |