Excels 56 ColorIndex Colors
Color Palette
Excel’s Color Palette has an index of 56 colors which can be used throughout your spreadsheet. Each of these colors in the palette is associated with a unique value in the ColorIndex. For reasons unknown, aside from the index value, Excel also recognizes the names for Colors 1 through 8 (Black, White, Red, Green, Blue, Yellow, Magenta, and Cyan).
The values in the above table were generated with help from the following macro.
Sub colors56()
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual
Dim i As Long
Dim str0 As String, str As String
For i = 0 To 56
Cells(i + 1, 1).Interior.colorindex = i
Cells(i + 1, 1).Value = "[Color " & i & "]"
Cells(i + 1, 2).Font.colorindex = i
Cells(i + 1, 2).Value = "[Color " & i & "]"
str0 = Right("000000" & Hex(Cells(i + 1, 1).Interior.color), 6)
'Excel shows nibbles in reverse order so make it as RGB
str = Right(str0, 2) & Mid(str0, 3, 2) & Left(str0, 2)
'generating 2 columns in the HTML table
Cells(i + 1, 3) = "#" & str & "#" & str & ""
Cells(i + 1, 4).Formula = "=Hex2dec(""" & Right(str0, 2) & """)"
Cells(i + 1, 5).Formula = "=Hex2dec(""" & Mid(str0, 3, 2) & """)"
Cells(i + 1, 6).Formula = "=Hex2dec(""" & Left(str0, 2) & """)"
Cells(i + 1, 7) = "[Color " & i & ")"
Next i
done:
Application.Calculation = xlCalculationAutomatic
Application.ScreenUpdating = True
End Sub
Hex equivalents used in HTML
Help support ExcelSuperSite – T-Shirts and Merchandise
Do you like this template and would like to help support us at ExcelSuperSite to continue to share great templates and content such as this – why not take a look at some of the t-shirts and merchandise we have on offer – click any of the images below to visit our store.
Please note – our T-shirts and merchandise are hosted on an external “Print on Demand” website Redbubble/ExcelSuperSite so when you click an image below you will be automatically taken to our store on that site.
Explore our other ExcelSuperSite Excel spreadsheet templates and downloads
Customers who downloaded this template also viewed …
Other places to explore spreadsheet templates and downloads
Other places to look for free spreadsheet templates: