to disable a cell in excel from entering data based on another cell's value - TechRepublic
Question
July 21, 2008 at 06:36 AM
ballu324

to disable a cell in excel from entering data based on another cell’s value

by ballu324 . Updated 18 years ago

hi,

i want to disable entering values/data into a cell based on another cell’s value. for ex, A1 is ‘Y’ then the user can enter value in B1, else if A1 is ‘N’ then the user should not enter any value in B1.

can any one help in achieve this…thanks in advance…

thans,
apparao

This discussion is locked

All Comments