Microsoft Excel 2003 Colour Index Values

Just recently I have been doing alot of Excel formula and VBA work with cell background colours and font colours.  When using cell colours and font colours in Excel VBA you refer to them by using ColorIndex.  However to work out the colour index you need to have a custom function that will then tell you the ColorIndex number.

So I thought why not just produce a JPEG that details the colour palatte in Microsoft Excel 2003.  So I did!  Below shows the cell colour, the colour name as called by Excel 2003, and then finally the numerical value each ColorIndex has.  The colours are in the order of the colour palatte in Excel 2003 working from left to right.

Microsoft Excel 2003 ColourIndex Values


To see ColorIndex in use view these posts below:

How to count Excel cells based on their background colour.

How to count Excel cells based on the font colour contained within them.

Excel formula based upon the background colour of a cell

2 thoughts on “Microsoft Excel 2003 Colour Index Values

  1. Mike Massen

    Would be great to have a function which can sum values in cells in a complete column that are NOT a particular colour eg Red which I understand is a 3 colour code ?

    ie By this format or similar:- =sumifcolour(range, colour condition)

    To sum everything in column A then used as =sumifcolour(A:A, 3)

    Or to put the sum at the head (ie into G1) of the same column =sumifcolour(G2:G, 3)

    Um how does one normally specify a range from some row to end of column so I don’t need an ‘end’ number ?

    The great thing is each time you extend the length of the spreadsheet and select the colour of cells added
    then you never have to amend the formula and it can be saved/locked for posterity/prosperity etc

    Anything like this around ?

  2. Pingback: recreating pre 2007 fill colours

Leave a Reply

Your email address will not be published. Required fields are marked *