Forum Discussion
Solved
Can you put 2 data validations on a single cell in Excel?
I need to do 2 things with a cell in Excel:
1. Limit data entry to the values 0-3.
2. Do not allow data entry in the cells until the value of another cell = 48.
Can I do this in Excel? It seems like you can only have 1 data validation rule per cell.
Assuming another cell is A1 and your Data Validation is on B1, use the following Custom formula:
=AND(A1=48, B1>=0, B1<=3)
3 Replies
Assuming another cell is A1 and your Data Validation is on B1, use the following Custom formula:
=AND(A1=48, B1>=0, B1<=3)
Lorenzothat did the trick! thank you very much!
- Glad I could help. At the bottom of my previous reply there's a link to Mark as solution - something that can help those who search this site. Thanks in advance
