This is a handy reference list for the default Workbook.Colors list in excel.
In case you are interested in generating the same list, here is the code. ‘Colors’ here refer to the sheet name and you may have to replace it with a relevant value (say, Sheet1).
Dim RowCount As Integer
Dim R As String, G As String, B As String
For RowCount = 2 To 57
Colors.Cells(RowCount, 1).Interior.ColorIndex = RowCount - 1
SplitColors ThisWorkbook.Colors(RowCount - 1), R, G, B
Colors.Cells(RowCount, 1) = RowCount - 1
Colors.Cells(RowCount, 2) = R & G & B
Colors.Cells(RowCount, 3) = Val("&H" & R)
Colors.Cells(RowCount, 4) = Val("&H" & G)
Colors.Cells(RowCount, 5) = Val("&H" & B)
And wait, SplitColors is not a built in function. This is a small piece of code that takes in a Long color and returns 3 hex strings. Basically, a long to hex converter for a color. That one follows.
Function SplitColors(RGB As Long, ByRef R As String, ByRef G As String, ByRef B As String)
Dim sRGB As String
sRGB = Right("000000" & CStr(Hex(RGB)), 6)
R = Left(sRGB, 2)
G = Mid(sRGB, 3, 2)
B = Right(sRGB, 2)
This is not a tutorial on how to use ColorIndex to set colors using Excel VBA. For details on that, take a look at this.