Dynamically Change Data Validation Type

[2696883]

Without using VBA, is it possible to have the data validation of a cell differ depending on the contents of another cell? For example, if "Yes" is entered into cell A1, then A2 is populated with a list of items. If on the other hand "No" is entered into A1, then A2 allows any value.

In other words, I am looking for a way to dynamically change the data validation TYPE (i.e. Any Value, Date or List etc) depending on the contents of a cell rather than dynamically change the contents of a list depending on the contents of a cell.

 

[Syedali]

Without using VBA, is it possible to have the data validation of a cell differ depending on the contents of another cell? For example, if "Yes" is entered into cell A1, then A2 is populated with a list of items. If on the other hand "No" is entered into A1, then A2 allows any value.

In other words, I am looking for a way to dynamically change the data validation TYPE (i.e. Any Value, Date or List etc) depending on the contents of a cell rather than dynamically change the contents of a list depending on the contents of a cell.

PFA. MY TRY

 

[2696883]

PFA. MY TRY

Thanks, but this is not exactly what I am trying to do. Please read the question carefully and see above for me comments - I am looking to change the data validation TYPE depending on another cell, and not change the list source. So depending on the contents of A1, cell A2 will be restricted to either a list, or a date, or text etc.

 

[Nebu]

Hi:

Please find the attached.

Thanks