Forum Discussion
Drop-down list with data validation rule
Hello everyone, I need some help :) I have two cells: B5 – amount, entered by users K5 – a drop-down list with offer types I want to create a data validation rule with an alert. For example: I...
You can do this using Data Validation with a custom formula in Excel. Here’s a step-by-step guide:
Select B5 (the cell where the amount is entered).
Go to the menu: Data → Data Validation → Data Validation…
In the Settings tab:
- Allow: Custom
- Formula: enter a formula that checks both the drop-down selection and the amount.
Enter the formula
Assuming your offer types are in K5, the formula is:
=IF(K5="offer1", AND(B5>=200, B5<=1000), TRUE)
Test it:
Choose "offer1" in K5 and try entering 2000 in B5 → You should see your alert.
Choose a different offer type → Any amount is allowed.
My answers are voluntary and without guarantee!
Hope this will help you.