RGB (R, G, B) to hex function

[stevenr]

Could somebody help me with a function for excel that converts RGB to hex color value? For example '255, 218, 0' to 'FFDA00'. Thank you in advance for your help.

[Aflatoon]

Try:



Function HexRGB(R As Byte, G As Byte, B As Byte) As String
HexRGB = Right("0" & Hex(R), 2) & Right("0" & Hex(G), 2) & Right("0" & Hex(B), 2)
End Function