title: conditional formatting using nested if with multiple conditions in excel
body: <p>I'm trying to format cells in a column using the conditional formatting tool in Excel. </p>
  
  <p>In order for the cell to be filled in green it must meet the following conditions:</p>
  
  <ul>
  <li><p>If field in column B is between 80 or 100 % show green</p></li>
  <li><p>If field in column A is under 3 months old and adjacent field in column B is between 60 and 100% show green</p></li>
  <li><p>If field in column A is under 1 months old and adjacent field in column B is between 40 and 100% show green</p></li>
  </ul>
  
  <p>If I only create one rule for each condition it works. See below:</p>
  
  <p>Rule 1</p>
  
  <pre><code>=IF(B1&gt;=0.8,IF(B1&lt;=1,TRUE,FALSE),FALSE)
  </code></pre>
  
  <p>Rule 2</p>
  
  <pre><code>=IF(A1&lt;3,IF(B1&gt;=0.6,TRUE,FALSE),FALSE)
  </code></pre>
  
  <p>Rule 3</p>
  
  <pre><code>=IF(A1&lt;1,IF(B1&gt;=0.4,TRUE,FALSE),FALSE)
  </code></pre>
  
  <p>When I combine all the rules it will only return whichever condition is first. See below:</p>
  
  <pre><code>=IF(B1&gt;=0.8,IF(B1&lt;=1,TRUE,
  IF(B1&gt;=0.6,IF(A1&lt;3,TRUE,
  IF(B1&gt;=0.4,IF(A1&lt;1,TRUE))))),FALSE)
  </code></pre>
  
  <p>I have also attempted using <code>AND</code>statements. Again the same issue, when I ran the second line to test if the condition would even work by itself it returned nothing. Please see below:</p>
  
  <pre><code>=IF(B1&gt;=0.8,IF(B1&lt;=1,TRUE,
  IF(A1&lt;3,IF(AND(B1&gt;=0.6,B1&lt;=1),TRUE,
  IF(A1&lt;1,IF(AND(B1&gt;=0.4,B1&lt;=1),TRUE,FALSE))))),FALSE)
  </code></pre>
  
  <p>Any advice on this would be welcome.</p>