Olivier has attended:
Excel Intermediate course
Excel Advanced course
Data Validation
Hi,
In a simple worksheet (Excel 2003), I'd like to add a rule such that:
If a cell is completed
THEN
other cell(s) in the same column must be completed.
e.g. a pop-up message appearing upon completion of initial cell
or
completion of initial cell creates rule whereby completion of subsequent cells is mandatory
Is the latter (mandatory) option possible? If not, what is best way to encourage data entry in subsequent cells?
Many thanks
Olivier
RE: Data Validation
Hi Olivier, thanks for your query. A professional solution to this problem would almost certainly involve some code to capture cell changes and alter the properties of subsequent cells accordingly. However, you might be able to achieve a similar result by using conditional data validation and dependent drop downs. There is a good walkthrough of these at this link:
http://blog.contextures.com/archives/2010/10/11/excel-conditional-data-validation/
...and I would set up the dependent drop down boxes, thereby driving the user to pick from certain lists (I would create lists with 0 entries to pick from when a user was not meant to put anything into a cell) and then protect the whole worksheet, preventing ad hoc data entry. All this will involve a certain amount of work but it can be done.
Hope this helps,
Anthony
