title: Changing ActiveCell's Font Colour and Background Colour
body: <p>Please could someone help me.  I have two functions in VBA for Excel.<br><br>  The one is to change the active cell's font colour and it works perfectly.  The second is to change the active cells background colour, and it refuses to work. <br><br> In stackoverflow there is another similar query and I am using that method yet this simply won't work.  What am I doing wrong?  I want to just reference 3 cells with numberic values from Excel to see what the colour is going to be on the fly.<br></p>
  
  <p><strong>Change ActiveCell Font Colour</strong> (WORKING)</p>
  
  <pre><code>Public Function FontColour(R, G, B)
  ActiveCell.Font.Color = RGB(R, G, B)
  End Function
  </code></pre>
  
  <p><br>
  <strong>Change ActiveCell Colour</strong> (NOT WORKING)</p>
  
  <pre><code>Public Function CellColour(R, G, B)
  ActiveCell.Interior.ColorIndex = RGB(R, G, B)
  End Function
  </code></pre>