title: Microsoft Excel Conditional Formatting Not Equal To Value/Blanks
body: <p>I have information in column B and C. I want column C to be formatted RED when it is NOT equal to "connected" and NOT blank.  I have it currently working in a sort of cheap way where I have ordered 3 different conditions.</p>
  
  <pre><code>Rule 1 - ="Connected" color green
  Rule 2 - =BLANK color white
  Rule 3 - &lt;&gt;"Connected color red
  </code></pre>
  
  <p>This only works due to the ordering..I was wondering if there was a way to accomplish rules 2 and 3 in one set of code.  I want this applied to entire C column, =$C:$C</p>