Single Cell Value From Either A Drop Down List Or Entered Manually, Depending On Selection

Hello All!

I have a cell in my spreadsheet that I use to control the size of a column. I formatted the cell as a number and added data validation to make sure the number is greater than zero. Then I realized that I need to also allow for the option of auto sizing the column as well. This would require a data validation list type with something like True and False for the choices.

What I want to be able to do is have it both ways. I want a drop down list in that cell with the options Auto Size or Custom. If Auto Size is selected the cell value gets set to that. If Custom is selected I then want to be able to type in a number.

ddl.png

http://i144.photobucket.com/albums/r...ps6fc68238.png

Is there a way to setup a cell such that the value is either an item from the drop down list or, entered directly (depending on the list selection)?

I know I can do it with dependent lists but that would require two cells, one for the auto size mode (true/false) and the other for manual width value.

Thank you.

Jan