title: Google Sheets Conditional Formatting multiple criteria excluding first date occurrence
body: <p>I have a bunch of assessment data for pre and post testing and am trying to highlight the rows in which a post-test(s) had 0 or negative gains. There is scaled gains data for the first test that I cannot remove (based on prior SY tests) and I would like to  exclude the first test for the school year. I have tried the following two formulas for conditional formatting:</p>
  <p>=(COUNTIF(ARRAYFORMULA($R$3:$R&amp;$U$3:$U),$R3&amp;$U3)&gt;1)*COUNTIFS($U3, &quot;<em>Reading</em>&quot;, $V3, NOT(MIN($V3)), $Z3,&quot;&lt;=0&quot;)</p>
  <ul>
  <li>Nothing highlights</li>
  </ul>
  <p>=(COUNTIF(ARRAYFORMULA($R$3:$R&amp;$U$3:$U),$R3&amp;$U3)&gt;1)*COUNTIFS($U3, &quot;<em>Reading</em>&quot;, $V3, MAX($V3), $Z3,&quot;&lt;=0&quot;)</p>
  <ul>
  <li>Negative gains, including the first test date highlight</li>
  </ul>
  <p>The (COUNTIF(ARRAYFORMULA($R$3:$R&amp;$U$3:$U),$R3&amp;$U3)&gt;1) portion checks the student id and test to highlight only those that have tested more than once and based on the research I did, the second portion *COUNTIFS($U3, &quot;<em>Reading</em>&quot;, $V3, MAX($V3), $Z3,&quot;&lt;=0&quot;) should act as additional criteria looking for the specific subject area (col U), test date (col V) and scaled gains (col Z)</p>
  <p>Any recommendations would be greatly appreciated!</p>
  <p>Here is a simplified version of the data (actual sheet has a lot more data related to the specific tests and students that is not relative to the formula): <a href="https://docs.google.com/spreadsheets/d/1NtD9JaIAqq0Lz-6LAvxSAXeo-WpwZtszped6Ou4iwzo/edit?usp=sharing" rel="nofollow noreferrer">https://docs.google.com/spreadsheets/d/1NtD9JaIAqq0Lz-6LAvxSAXeo-WpwZtszped6Ou4iwzo/edit?usp=sharing</a></p>