Forum Discussion
How to Convert Color Map/Grid Values
Hi, Noob here, I have a software generated Excel report with color map grids that are auto generated with values I would like to change. The grids are usually not symetrical and roughly follow t...
Use Excel Conditional Formatting (Start → Conditional Formatting → Color Scale) to automatically convert values to colors, or extract RGB values through VBA code:
Function GetColorHex(Cell As Range) As String
GetColorHex = Right("000000" & Hex(Cell. Interior.Color), 6)
End Function
Call the formula = GetColorHex(A1) to get the color code.