Data Validation Auto Select

[AllanSull]

Is there a way to automatically populate a dropdown if that dropdown only has 1 option to select from?

So when option 1 is selected, in this example "Yes", the only available value in Option 2 is also "Yes", so instead of making a user select this can it be automatically selected?

 

[Chris Macro]

Sure, just put an IF function in the cell. As long as the outputs don't conflict with the data validation you're golden. Try something like this: =IF(C2="Yes","Yes","")

 

[AllanSull]

It won't allow me to use a formula in the cell, I get the error message "A user has restricted values that can be entered into this cell".

 

[Chris Macro]

What version of Excel are you using? I was able to do this in Excel 2007. Can you show me the exact formula you input? Are you using the List Data Validation option?

 

[AllanSull]

Excel 2010. I am using the List Data Validation, as shown in my screenshot in Post#1.