VBA Colour Index Numbers

Here's the Excel colour picker as it appears when requested from the Font Color toolbar button. Point at the colour samples to see the name and VBA index number of each colour.

Black (1) Brown (53) Olive Green (52) Dark Green (51) Dark Teal (49) Dark Blue (11) Indigo (55) Gray-80% (56)
Dark Red (9) Orange (46) Dark Yellow (12) Green (10) Teal (14) Blue (5) Blue-Gray (47) Gray-50% (16)
Red (3) Light Orange (45) Lime (43) Sea Green (50) Aqua (42) Light Blue (41) Violet (13) Gray-40% (48)
Pink (7) Gold (44) Yellow (6) Bright Green (4) Turquoise (8) Shy Blue (33) Plum (54) Gray-25% (15)
Rose (38) Tan (40) Light Yellow (36) Light Green (35) Light Turquoise (34) Pale Blue (37) Lavender (39) White (2)

Excel's Hidden Colours

Here is a table of the colours that are hidden away. Those colours with names can be found on the additional panel added to the colour picker when it is requested from a dialog box. The colours with just index numbers can be applied only though VBA.

Close this window