LinkBack URL
About LinkBacks
I have to have validation for an input cell, the number input by the user must be above certain number, but only if another cell says a certain thing, for example if it says High season, then the user has to input at least 5.
Validation on input based on another cell
I have to have validation for an input cell, the number input by the user must be above certain number, but only if another cell says a certain thing, for example if it says High season, then the user has to input at least 5.
Hi, and welcome to the forum
With "High Season" in B1 enter the following custom validation in A1
Formula:
Please Login or Register to view this content.
..edit - sorry missed the bit about 'at least 5' ..back in a minute
instead..
Formula:Please Login or Register to view this content.
Last edited by Richard Buttrey; 10-24-2014 at 07:40 AM.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
If the minimum value is conditional on the text you might need to look up its value using
= INDEX( minimum, MATCH(Season,List_Season,0) )
within the validation form.
SO lets say B1 can say High season, Low season or Medium season.
A1 is an input where someone puts a number, and only if the season in B1 says High season there is a minimum number that must be input.
S0 the validation must only be applied if B1="High season"
The formula you gave Richard does not depend on B1.
Hi,Originally Posted by cultofcargo
I'm not sure the point you're making. The Data validation formula I gave you DOES depend on B1. That's the bit that says B1="High Season"
If B1 contains "High Season" then A1 will accept a 5 and above. Without High Season in B1 A1 will accept anything.
I'm assuming the Input cell is A1 and your use of the words 'Other cell' refers to B1. That being the case the formula I gave you works in my copy of Excel.
In my copy the validation is being applied no matter what is in B1
I am using excel 2013 on my windows 8 machine
Can I get more assistance with this please?
Have you used the validation formula I gave you in post #2?
If so and since you claim it's not working then upload your workbook. We're not psychic, least not very often so can't comment unless we're looking at what you see.
https://www.dropbox.com/s/mjtvm5ugna...xcel.xlsx?dl=0
This is the workbook.
The formula in the second post did not only apply the validation in high season
Let me know if the link works properly and thanks.
Last edited by cultofcargo; 10-26-2014 at 08:22 PM.
The link didn't lead to a file. error 404
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
Try again, post edited.
Would you upload the file to this forum please? Many of us prefer not to use dropbox type sites, that's why the forum has its own facility.
Holiday park excel.xlsx
Has this worked? test
EDIT: ok, here it is
Hi,
You have not used the type of validation I gave you. I suggested you use a Custom formula validation. You're using a normal 'Between' 2 & 15 validation.
Not only that but between 2 & 15 bears no resemblance to your first requirement that the validation should be >=5.
You really need to be quite clear and tell us EXACTLY what you want, and then when you're given a solution use what you're given, not what you think it should be, and certainly not say that the solution you've been given doesn't work when you've not bothered to use it.
Can I suggest you go back to square one and tell us with reference to the new workbook exactly how you want it to work in terms of validation cells.
I put in the forumula you gave me multiple times and it never only applied validation when High season was in E18 for whatever reason. Ignore what validation is in the fields right now.
Square one:
When E18 is "High season", the user can only input 5 or above in C16.
When E18 is anything but High season, no validation is applied.
I hope this is clear
The formula that Richard Buttrey gave you is correct but you didn't apply it correctly. The cell for the Data Validation was changed from A1 to C14 and instead of B1 the cell for High Season is now E18 and instead of just being greater than or equal to 5 the conditions now seems to be 2 to 15. If all the above is correct, Richard Buttrey's formula should have been changed to:
Formula:Please Login or Register to view this content.
and it must be entered in the Custom area as indicated by Richard Buttrey.
Thanks everyone, my problem has been solved.
I gave reputation to all.
Thank you for the feedback and the rep points that you awarded to those who helped you.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks