/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 vote228 views1 answer
Excel vba compare 2 rows
VBA
1 vote244 views1 answer
How to remove zeros in excel
VBA
0 vote251 views1 answer
Tester si une case est vide vba
VBA
0 vote253 views1 answer
Excel vba protect scenarios
VBA
0 vote269 views1 answer
Vbnet check if string is only numbers
VBA
0 vote241 views1 answer
Telephon call in vba
VBA
4 votes239 views1 answer
Vba create directory
VBA
0 vote225 views1 answer
Vb.net round to 2 decimal places
VBA
0 vote227 views1 answer
Excel vba join variant array
VBA
0 vote286 views1 answer
Vba change active sheet
VBA