Data Validation Custom

Hi Aquila, thanks for your query. It's difficult to achieve what you want using basic text entry into a cell - you'd need some code to really make it happen - but try using dependent drop downs instead, particularly if the values you want to allow the user to enter are limited. Here's a link to a walkthrough of how to achieve dependent dropdowns:

http://www.bluepecan.co.uk/excel_training_cascading_drop_down_lists_using_data_validation.html

Hope this helps,

Anthony