title: Excel, Creating 3 conditions for Conditional Formating
body: <p>My situation is this.  I have an excel sheet that contains 6 columns I need to compare G:L,  </p>
  
  <p>in these  columns each cell contains a Dollar value or are Blank.
  I need to figure out how I can return into column M 3 distinct values </p>
  
  <ul>
  <li>ALL cells within a row Match </li>
  <li>The row Contains Blanks </li>
  <li>NOT all rows Match</li>
  </ul>
  
  <p>I used =NOT(STDEV(G3:L3))
  which gave me True / False / #DIV/0!  but when I tried conditional formatting with 3 Rules</p>
  
  <pre><code>Formula:=$M4:$M2693=TRUE (background GREEN) Applies to =$A$4:$L$2693
  Formula:=$M4:$M2693=FALSE (background RED) Applies to =$A$4:$L$2693
  Formula:=$M4:$M2693=#DIV/0! (background YELLOW) Applies to =$A$4:$L$2693
  </code></pre>
  
  <p>I would get no Yellow rows,  DIV/0 Rows would be the colour of what ever row was above them.</p>
  
  <p>I figure if I can have column M  return 3 distinct values be they A, B C 1,2,3 or anything that isn't #DIV/0!  I should be able to make conditional formatting work</p>
  
  <p>BONUS is if I can have it return 4 values the 4th value indicating ALL rows are Blank,  since that would be heading rows but it doesn't really matter as I can manual edit those 40ish rows.</p>
  
  <p><strong>* EDIT *</strong>
  Tom Lead me in the right direction,  but to get the formatting perfectly I did have to make a few modifications</p>
  
  <pre><code>    =COUNTBLANK($H$3:$L$3)=5 (No Formatting) 
      =STDEV($H3:$L3)&gt;0 (Red)
      =STDEV($H3:$L3)=0  (Green)
      =COUNTBLANK($H3:$L3)&lt;5 (Yellow)
  </code></pre>
  
  <p>Then it worked fantastically,  So if you're reading this because you have the same problem tweeking the order can have a lot to do with your conditional formatting</p>