title: excel conditional formatting for minimum rainfall
body: <p>As you may know, there is "trace" rainfall if it rains but the amount is less than 0.1mm, so we have 0.0 mm &lt; Trace &lt; 0.1 mm.</p>
  
  <p>Now for example, I have a table of rainfall data as follow:</p>
  
  <pre><code>Year Jan Feb Mar Apr
  2011 24.0 0.0 9.4 57.8
  2012 Tr 6.8 29.3 109.2
  2013 Tr 46.1 49.3 71.0
  2014 0.1 7.9 0.1 14.6
  2015 15.4 Tr 25.3 (blank)
  </code></pre>
  
  <p>If I want to highlight the max. rainfall for each month with a yellow fill. That's very simple, just set a rule that highlights the top 1 item.</p>
  
  <p>But the problem is highlighting the min. rainfall for each month with a green fill. 
  If I simply set a rule that highlights the bottom 1 item, it is fine for Feb, Mar and Apr. (2011 Feb, 2014 Mar and 2014 Apr will be highlighted.) </p>
  
  <p>However, for Jan, 2014 Jan will be highlighted. But I expect 2012 and 2013 to be highlighted as Trace &lt; 0.1 mm.</p>
  
  <p>If I add a rule that highlights the cell which contains "Tr" in addition to the bottom 1 item rule:<br>
  1) for January, 2012, 2013, 2014 are all highlighted (I just want 2012&amp;2013)<br>
  2) for February, both 2011 and 2015 are highlighted (I just want 2011)</p>
  
  <p>I also tried the following:<br>
  1st rule: Formula: =AND(COUNTBLANK($B2)=0,$B2=0) --> Format Green Fill [Stop if true checked]<br>
  2nd rule: cell which contains "Tr" --> Format Green Fill [Stop if true checked]<br>
  3rd rule: bottom 1 item --> Format Green Fill [Stop if true not checked]<br>
  The logic is: <br>
  If there are 0.0 (not blank cell),"Tr" &amp; 0.1, highlight 0.0 only but not the other two...<br>
  If there is no 0.0 but there are "Tr" &amp; 0.1, highlight "Tr" only but not 0.1<br>
  If there are no 0.0 and "Tr" but there is 0.1, highlight 0.1<br>
  However this method fails... I think it's because "Stop if true" isn't for this purpose. </p>
  
  <p>Is there any method to highlight the cell correctly as I want? </p>