/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 vote199 views1 answer
Vbnet round to nearnest thousand
VBA
22 votes374 views1 answer
Excel vba check if directory exists
VBA
0 vote177 views1 answer
Vba sheet visible
VBA
0 vote228 views1 answer
Visual basic run command
VBA
0 vote185 views1 answer
VB Error Code BC30201
VBA
3 votes189 views1 answer
Vba http request json
VBA
0 vote181 views1 answer
Vbnet find highest value in chart
VBA
0 vote192 views1 answer
How to get the value of optionbutton in vba
VBA
0 vote201 views1 answer
Vba random number
VBA
1 vote175 views2 answers
Vba string to date
VBA