Two data validations

[vcastle]

Is it possible that one cell contain two data validations? For example A1 contains a data validation for a drop down menu under "list"  and a data validation under "custom"?

[#2 · Accepted solution]

@vcastle 

Check this website: Multiple Data Validation on one cell 

[#3]

That was it, thank you! @Rr_. How would you combine these two functions using the "=OR"

=COUNTIF(B$32:B$59,"=P")+COUNTIF(B$32:B$59,"=CP")<= B$61

=COUNTIF($AL$2:$AL$16,B26)=1

I tried doing 

=OR(COUNTIF($AL$2:$AL$16,B26)=1,AND(B26>=(B$26:B$28,"=O")<= B$30))) but I get an error message 

[#4]

@vcastle 

You're having an error message because you do not have a function on your "(B$26:B$28,"=O")" formula....
maybe try adding countif function on that.

=OR(COUNTIF($AL$2:$AL$16,B26)=1,AND(B26>=COUNTIF(B$26:B$28,"=O")<=B$30))