title: Google Sheets Formula for "If x cell = less than 100% AND y cell = date greater than one year ago then format row color to red
body: <p>I have a training tracking spreadsheet for about 1000 people.</p>
  
  <p>One of the requirements is that they meet all their training requirements in less than 12 months from the date of hire or promotion.</p>
  
  <p>I have a column that calculates the percentage of their required training.</p>
  
  <p>I have a column that shows their date of hire or promotion.</p>
  
  <p>What I have no idea how to do is to correlate those two data sets so that I can use it as a "trigger" to highlight the row of the person who is overdue to red.
  I know how to do it with one or the other, but for an IF THIS AND THIS THEN formula in Google Sheets I have no idea. </p>
  
  <p>The closest I can think of is a custom formula in conditional formatting of:</p>
  
  <pre><code>=AND($BY2&lt;1, $J2&gt;Today-365)
  </code></pre>
  
  <p>But it won't work for me :(</p>