LinkBack URL
About LinkBacks
b624333 
Is it possible to have a drop down list only if another cell is filled with a specific criteria?
Is it possible to have a drop down list only if another cell is filled with a specific criteria?
yes , you can have dependant dropdowns - which would also apply to your criteria
http://www.contextures.com/xlDataVal02.html
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Not quite what I was looking for. I was hoping to fill cell B2 with ONLY the word "fail" if cell A2 was filled.
In other words, the user would be unable to type anything in B2 unless A2 was filled. If A2 was indeed filled, then the only thing they could type (or select from a dropdown list) would be the word "fail".
use
Data Validation
and a custom validation and you can put this in the formula
=AND(A2<>"",B2="fail")
that would only allow the word "fail" to be entered if A2 is not blank
No, that doesn't work at all. It allows all values. Wouldn't you need to use an IF statement?
no dont need an of
data validation works on the formula resolving to TRUE
so the AND statement will be true only if two conditions are met in the AND
and as one is "fail" - then its only TRUE when you have "fail" in the cell
Oh. I apologize. I just retried it and it works now. Thank you so much.
The above data validation allows any value to be entered in B2, not just "fail".
excellent thanks for the rep
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks