title: Conditional formatting does not seem to be applied after updating cells
body: <p>is there a way to refresh a cells conditional formatting using VBA?</p>
  
  <p>Issue:
  I am in a situation where I have a cell (A1) referencing another cell (B1), which contains a =SUM() number value with the format of "number, 2 decimal places", but cell (A1) has a conditional formatting on it of "Cell Value >= 1000" and with that I am applying a custom format, otherwise it uses a Currency format for euros.</p>
  
  <p>I update the values using VBA and then do</p>
  
  <pre><code>Application.CalculateFull
  </code></pre>
  
  <p>which updates my formulae but this conditional format is only getting applied the first time the value goes over 1000... if it is less than 1000 it does not go back to its original format.</p>
  
  <p>Any one had this problem before and knows how to update the conditional formatting? short of using VBA to select the cell and refresh it some how?</p>