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 li...
Assuming another cell is A1 and your Data Validation is on B1, use the following Custom formula:
=AND(A1=48, B1>=0, B1<=3)
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
