title: Conditional Formatting With Nested If Statements [excel]
body: <p>I have a PivotTable that, for this example's sake, has three columns:  </p>
  
  <p>Column B contains non-negative number values. </p>
  
  <p>Column D contains non-negative number values.</p>
  
  <p>Column C shows the percent of change from Column D to Column B (ie, D1=1 and B1=2, C1=100%).</p>
  
  <p>I have a Conditional Formatting rule set up so that if any value in Column C is greater than 10%, the cell is highlighted in red.  However, this does not work when a cell in Column D has a value of zero, and the corresponding cell in Column B has a value higher than zero, because the result would be infinity.  </p>
  
  <p>My goal is to set up a rule so that if any cell in Column D has a value of zero, and any cell (on the same row) in Column B has a value greater than zero, the corresponding row in Column C will still be highlighted in red.  Since I have non-negative numbers in my data, technically as long as Column D is zero and Column B is not zero, this would satisfy the formula.  </p>
  
  <p>I've tried using the following formatting rule to apply to Column C but have not been successful.  I'm sure this could be also be accomplished using nested IF statements: </p>
  
  <pre><code>IF(D$=0 AND(B$&lt;&gt;0), TRUE, FALSE)
  </code></pre>