Hi Forum,
I need a cell to restrict the value entered based on a selection in a drop down box i have in another cell.
Cell C3 has options a, b, c, d
Cell C13 needs to be restricted to whole numbers based on the option chosen from drop down list in C3
if c3=a then 1<C13<50
if c3=b then 1<C13<10
else 1<C13<3
Im using Excel 2010
I select C13 and under Data Validation > Settings > Allow > Custom and Formula:
The validation box accepts this but regardless of the value i enter it returns an error saying the value is not valid. What options and/or code should I change?
Thank you in advance.
Bookmarks