title: Case sensitivity in Excel data validation with lists
body: <p>I might be overthinking the implementation in excel data validation.</p>
  
  <p>Basically I would like to have "Data Validation" on the list to be case sensitive and I cant enter the comma separated values due to long list of texts. </p>
  
  <p>What I would like to achieve is I.e., If I have Yes and No in the list then I would like to have something like EXACT(List A, List B) in the data validation. Please find the attached screenshot for clarification.</p>
  
  <p><img src="https://i.stack.imgur.com/Btpmu.png" alt="https://i.stack.imgur.com/Btpmu.png"></p>