title: Disable and Enable cells based on another cell in Google Spreadsheets
body: <p>The first column of my spreadsheet has dropdown lists in each cell with the options "yes" and "no".</p>
  
  <p>If "yes" is selected, I want to enable the cell in the same row, next column with another dropdown list with options "red" and "blue". If "no" is selected, then the next cell should remain disabled.</p>
  
  <p>So far I have tried the data validation menu with custom formula is set to <code>=if(B2="Yes", "red", "blue")</code> in cell B3, but it doesn't work.</p>
  
  <p>How can I do this?</p>