title: Conditional formatting on Multiple Rows based on cell value
body: <p>In my Google Form, I have custom formatting setup for my dropdown lists that will highlight the entire row based on the value chosen. </p>
  
  <pre><code>Custom formula is
  =$B3="Highlight: 1 Row"
  </code></pre>
  
  <p>But how can I highlight multiple rows if I wanted to? <br></p>
  
  <hr>
  
  <p><strong>Google Sheet Example:</strong> <a href="https://docs.google.com/spreadsheets/d/1IUj4aiz9iQ9tOQBiK-xJmhsNYr_Uo83AZxGJ8EOTIu8/edit#gid=0" rel="nofollow noreferrer">Highlight Multiple Rows</a> <br>
  <strong>Screenshot Example:</strong></p>
  
  <p><a href="https://i.stack.imgur.com/RZ8cR.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/RZ8cR.png" alt="enter image description here"></a></p>
  
  <p><br></p>
  
  <h1>UPDATE (01-26-2017)</h1>
  
  <p>The purpose of this "multi row" feature will be used inside a more robust spreadsheet that generates Google Forms from a Google Sheet. For this particular use case, there are many different "dropdowns" for the user to choose from that control where the user can type. This can quickly become hard to navigate the longer your sheet becomes. The best way it seems to handle this is through conditional formatting.</p>
  
  <ul>
  <li><a href="https://docs.google.com/spreadsheets/d/1IUj4aiz9iQ9tOQBiK-xJmhsNYr_Uo83AZxGJ8EOTIu8/edit#gid=0" rel="nofollow noreferrer">Highlight Multiple Rows</a> <em>(Test Google Sheet)</em>        </li>
  <li><a href="https://www.youtube.com/watch?v=tockyjdnO_s" rel="nofollow noreferrer">Create Form From Sheet</a> <em>(YouTube Tutorial)</em>      </li>
  <li><a href="https://docs.google.com/spreadsheets/d/1ClPucMFkpp3sSegMDMOJV2Rh0csRqAMOlWPArqK7uKQ/edit#gid=334670914" rel="nofollow noreferrer">Create Form From Sheet</a> <em>(Google Sheet)</em>      </li>
  <li><a href="https://script.google.com/d/1nFjMguR8pRW7Kf8qVeRy_OSdpnq5BjX_IWX62r_Rj6b6ysRhX3oWeBde/edit?usp=sharing" rel="nofollow noreferrer">Create Form From Sheet</a> <em>(Google Script)</em>     </li>
  </ul>