title: Excel 2007 - conditional formating - how to turn colour codes into colours?
body: <p>I have a very simple macro code which shows the colour of the colour code which is recorded inside a cell:</p>
  
  <pre><code>Sub ShowColour()
      ColCod = Selection()
      With Selection.Interior
          .Pattern = xlSolid
          .PatternColorIndex = xlAutomatic
          .Color = ColCod
          .TintAndShade = 0
          .PatternTintAndShade = 0
      End With
  End Sub
  </code></pre>
  
  <p>I am now looking for some way for changing the content of the cell into another colour code and be immediately shown it's colour. I have experimented with conditional formating, but it seems that I can only choose amongst pre-defined formats. Can anybody give me a hint?</p>