What Colours Are Available To Use With a Custom Number Format EXCEL

Question

NOTE. Not to be confused with Conditional Formatting

When using the Custom Numbers in Excel I often use RED font for a negative number.

See image below.

What other Colours can be used in this way ?

I know Green & Blue work, but is there a full list available ?

Answer 1

In addition to the 8 named colors you can also use [ColorX], where X is a number between 1 and 56. The named colors are identical to [Color1] to [Color8].

A quick way to see all the colors provided is to run the following in the immediate window in VBA (preferably in an empty workbook):

for x = 1 to 56:cells(x,1) = "AAAA":cells(x,1).numberformat = "[COLOR"&x &"]@":Next x

Answer 2

According to this, There are only 8 colors, the list is:

[Black]

[Green]

[White]

[Blue]

[Magenta]

[Yellow]

[Cyan]

[Red]

It applies to Excel 2016, Excel 2013, Excel 2010 and Excel 2007

Answer 3

If l'm not mistaken Excel has 56 Colour available to use with Number Format. Either use Name or Colour number.

[Blue Grey] $#, ##0; [Sea Green]-$#, ##0
[Color4] $#, ##0; [Color3]-$#, ##0

  

Answer 4

You can change the colors also by using color4 or color44 for orange. Just play with the numbers to get more colors.