Question Locked
to disable a cell in excel from entering data based on another cell's value
0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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