Can you put 2 data validations on a single cell in Excel?

[ebethfoster]

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.

[#2 · Accepted solution]

@ebethfoster 

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]

@L z.that did the trick! thank you very much! 

[#4]

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