conditionally restrict input in excel

[perry_fawn]

Hi,

I've designed a spreadsheet for user input and I am wondering if I can conditionally set data validation. Here is what I would like to do: on the "Input" sheet, if cell AF15= 1 then allow user to input a number between 16-70 in cell F15, otherwise allow the user to input a number between 0-80. Is there anyway to do this with the data validation tools that are already in excel?

Thanks,
Fawn

 

[perry_fawn]

Ok, I figured it out by using a simple IF statement in the formula bar on the data validation software.