title: Excel formula do not update automatically
body: <p>I have created a simple excel formula to know what is the color of the font of the cell A1</p>
  
  <pre><code>Function GetFontColorIndex(elrango As Range) As Integer
          Application.Volatile
         GetFontColorIndex = elrango.Cells(1, 1).Font.ColorIndex
  End Function
  </code></pre>
  
  <p>In <a href="/questions/tagged/excel-2010" class="post-tag" title="show questions tagged &#39;excel-2010&#39;" rel="tag">excel-2010</a>:<br>
  <em>File > Options > Formulas > Workbook Calculation > Automatic</em> is checked</p>
  
  <p>In cell <code>A1</code> I have a number, and in cell <code>A3</code> I have<br>
   <code>=GetFontColorIndex(A1)</code></p>
  
  <p>but when I change the font of cell <code>A1</code>, the formula does not update automatically on cell <code>A3</code>. I have to click <code>shift+F9</code> and then it works.</p>
  
  <p>Any idea why is not showing the number of the font automatically?</p>