| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Blocking data entry
Is it possible to configure a cell or cells to be unavailable for data entry
unless data is entered in another cell or cells first? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Blocking data entry
You can do this with Data Validation. Select the cell whose entry you
want to restrict. Open Data Validation dialog from the Data menu, choose "Custom" on the Allow list, and enter =LEN($D$1)0 where $D$1 is the cell which must have data in it in order to enter data in to the validated cell. Cordially, Chip Pearson Microsoft Most Valuable Professional, Excel, 1998 - 2010 Pearson Software Consulting, LLC www.cpearson.com On Thu, 25 Feb 2010 13:03:01 -0800, JP wrote: Is it possible to configure a cell or cells to be unavailable for data entry unless data is entered in another cell or cells first? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Protected workbooks blocking transfer of data | Excel Discussion (Misc queries) | |||
| Auto entry of data based on entry of text in another column or fie | Excel Discussion (Misc queries) | |||
| Data Entry Online, Data Format, Data Conversion and Data EntryServices through Data Entry Outsourcing | Excel Discussion (Misc queries) | |||
| Cell Entry That Locks Selected Cells From Any Data Entry. | Excel Worksheet Functions | |||
| Blocking entry of data in a cell | Excel Worksheet Functions | |||
Hybrid Mode
