I want to create a data validation list, with if condition.

When the condition meets true it should show the list and if false then it should allow to enter value manually.

How to do this.

Thanks in advance