/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

0 vote210 views1 answer
Excel vba protect shapes
VBA
0 vote208 views1 answer
Vba clear collection
VBA
1 vote197 views1 answer
Vba reverse string
VBA
0 vote215 views1 answer
Vba horizontalalignment
VBA
-1 vote198 views1 answer
Vba code to add new column in table
VBA
0 vote192 views1 answer
Vba code to open a file with login rights
VBA
0 vote192 views1 answer
Putting marquee in vb.net
VBA
0 vote178 views1 answer
Excel vba open browser
VBA
0 vote188 views1 answer
Vba option button selected
VBA
5 votes209 views1 answer
Excel vba left word from Long Integer
VBA