I want to get HEX color value from cell (range) color.
The following links are giving wrong results.
https://stackoverflow.com/a/24216193/13075931
https://stackoverflow.com/a/50479544/13075931
You can find detailed explanation in the following picture.
Update: Thanks for good answers but I have found better solutions in the following link.
https://excelribbon.tips.net/T010180_Determining_the_RGB_Value_of_a_Color.html
Simpler
Function GetColorInHex(cc As Range) As String
Dim s As String
s = Hex(cc.Cells(1).Interior.Color)
s = String(6 - Len(s), "0") & s
GetColorInHex = Right(s, 2) & Mid(s, 3, 2) & Left(s, 2)
End Function