You are here:

Excel/Enabling data entry into cell based on Value

Advertisement


Question
Dear Expert,

Greetings.

My requirement is very basic.

In Column A , I am asking User to Enter Two Values (Drop Down list) : Yes/No.

If User selects Yes in Column A , say cell A2 , he can enter values in B2 and C2 but if he selects No , cells B2 and C2 remains locked.

Can it be done with some data validation rules , without any coding kind of thing.

Please guide.





Please guide how this conditional values based data restriction can be done.

Answer
Navin:

You cannot accomplish a truck "lock" of cells in the manner you requested unless you use visual basic programming.  Here are some links supporting my response:

http://www.mrexcel.com/forum/excel-questions/49207-lock-cellsbased-condition-ano
http://social.msdn.microsoft.com/Forums/office/en-US/bc273121-1299-4a2a-bb78-f51

You could simulate a "lock" by using conditional formatting to color the cell text and background gray.  This would make the data inside the cells invisible, but you could still type into them.

Alternatively, the code for creating a true "lock" is not terribly complex.

Sincerely,

Nathan
About Excel
This topic answers questions related to Microsoft Excel spreadsheet (or workbook) stand-alone or Mircrosoft Office Excel including Excel 2003, Excel 2007, Office 2000, and Office XP. You can get Excel help on Excel formulas(or functions), Excell macros, charting in Excel, advanced features, and the general use of Excel. This does not provide a general Excel tutorial nor the basics of using a spreadsheet. It provides specific answers to using Microsoft Excel only. If you do not see your Excel question answered in this area then please ask an Excel question here

Excel

All Answers


Answers by Expert:


Ask Experts

Volunteer


Nathan

Expertise


This expert requires a donation of $5 for questions answered (satisfaction guaranteed). Isn't $5 a value for this experts time?
Microsoft Excel questions related to advanced formulas, Pivot Tables, filters, forms, graphs, and just about anything else (EXCEPT Visual Basic Coding/Programming and Macros, I don't answer questions in those categories).

Experience

I have been using spreadsheets since Lotus 1-2-3 was released.

Education/Credentials
Certified Public Accountant (CPA)

©2016 About.com. All rights reserved.