title: Google Sheets - Change row color once multiple boxes are checked
body: <p>In Google Sheets, I would like each row to turn green, once two of the checkboxes (in Columns F and G) are checked for that row.</p>
  
  <p>I have tried using conditional formatting with the following formulas applied to range <code>A2:I145</code>:</p>
  
  <pre><code>=IF($F2=TRUE,1)=AND($G2=TRUE,1)  /* This colors the row when cells are unchecked */
  
  =IF($F2:$G2=TRUE) /* This does not color the row at all */
  </code></pre>
  
  <p>I know that if it was only based on one checkbox, it could be accomplished with <code>=$F2=TRUE</code>. There is documentation on this <a href="https://www.benlcollins.com/spreadsheets/google-sheets-checkbox/" rel="nofollow noreferrer">here</a>, but they don't give an example with requirement of two checkboxes.</p>
  
  <p>Is there a simple function that can perform this task?</p>