title: Excel conditional formatting - Highlight numbers greater than 5 but ignore any formula
body: <p>I am having a strange problem, I have a column with this formula in each row respectively:</p>
  
  <pre><code>=IF(C6="";"";D6-LEN(B6))
  </code></pre>
  
  <p>It works great, if the cell next to it is empty, make it an empty cell, if not, show the calculated length. However, when I try to use conditional formatting to make it red when the length is greater than 5, it highlights the cells that are 'blank'(have a formula in but are displaying blank). Any ideas as to why this is happening would be greatly appreciated.</p>
  
  <p>PS. I am currently using Open Office 4.0.1 and it seems to work fine, but when I send the document to a client(Excel 2010) it highlights the empty cells. I have tried clearing the conditional formatting and using Excels built in conditional for-matter and it does the exact same thing.</p>
  
  <p>Thanks in advance, James.</p>