/VBA/Excel vba highlight cells using the hex color value within the cells

Excel vba highlight cells using the hex color value within the cells

'VBA function to color cells in selected range based on the hex
'color number entered in each cell. For example, #FF69B4

Sub ColorCellsByHex()
    Dim r
    If TypeName(Selection) <> "Range" Then Exit Sub
    For Each r In Selection
        r.Interior.Color = Abs(("&H" & Mid(r, 6, 2) & Mid(r, 4, 2) & Mid(r, 2, 2)))
    Next
End Sub

Source: academy.excelhero.com

Similar codes

1 vote155 views1 answer
How to do error handling in access vba
VBA
0 vote169 views1 answer
Vbs send keys
VBA
0 vote209 views1 answer
Amd64 vs arm64 linux
VBA
0 vote166 views1 answer
Vbnet hex to binary
VBA
0 vote180 views1 answer
Power query M substract minimum value of column -dax
VBA
5 votes189 views1 answer
Vba low byte from INTEGER
VBA
0 vote181 views2 answers
Open url from vba
VBA
0 vote207 views1 answer
Vba foreach 2d array
VBA
25 votes316 views2 answers
Excel vba folder exist
VBA
5 votes172 views1 answer
Xl vba double quotes in string literal
VBA