/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 vote240 views1 answer
Excel vba hide gridlines
VBA
0 vote229 views1 answer
How to use if condition in time vba
VBA
1 vote254 views1 answer
Perform http request in vb.net
VBA
1 vote244 views2 answers
Excel vba password protect
VBA
0 vote278 views1 answer
Vba userform textbox wrap text
VBA
0 vote242 views1 answer
Vb streamreader
VBA
0 vote273 views1 answer
Vba foreach 2d array
VBA
0 vote255 views2 answers
S yyyy-MM-dd em vb net
VBA
-1 vote229 views1 answer
For i in range vba
VBA
0 vote242 views1 answer
Set column width of datagridview vb.net
VBA