I am trying to find the colour code numbers in Excel 2007, which are
backwards compatible with e.g. Excel 2003.
Example
Selection.Interior.Color = 3 'red cell
Selection.Font.Color = 2 'white font
When running this code, it makes both the cell background and font
colour black. This is due to the increased number of colours in Excel
2007 and each colour starting at the very low end of the colour
spectrum. I'd like to know if there's a way of using true colours like
in Excel 2003.