Conditional Cell Validation

[eggyjla]

Currently using a Validation List for inputting data into a cell. How do I make this conditional, meaning IF cell A1 "='Defined" then cell B1 would be validation list "=Vlist", otherwise if A1 "='User-Defined", then cell B1 would allow a value manually entered other than what is in Vlist.

 

[Jonmo1]

You can use formulas in the Validation List "Source" Box..

=IF(A1="Defined",Vlist,User-Defined)

 

[Mtyler]

I just wanted to say that this helped me do exactly what I've been trying to do for ages, and no one else in my office could help/do it.

Big thanks!