title: combine list and custom formula data validation in one cell
body: <p>I am working on a spreadsheet that will be used to order uniforms. </p>
  
  <p>All the sizes are contained on a separate sheet.</p>
  
  <p>I am trying to use data validation to ensure that whomever inputs a size, only selects from available sizes chosen from a list.</p>
  
  <p><strong>AND</strong></p>
  
  <p>that if they have selected a size for one sex, that they cannot input a size from another.</p>
  
  <p><br><br>
  <a href="https://i.stack.imgur.com/B29AB.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/B29AB.png" alt="example"></a></p>
  
  <p><a href="https://i.stack.imgur.com/xOd1T.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/xOd1T.png" alt="example2"></a></p>
  
  <p>The issue I'm having is that I can only choose between having a dropdown list or using my custom formula that performs the appropriate checks I need.</p>
  
  <p><strong>Is there a way to have more than one Data Validation setting per cell or to combine settings?</strong></p>
  
  <p>My custom formula: <code>=AND((SYSVAR!$G$3:$G$45), ISBLANK(J9))</code></p>