/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

3 votes287 views1 answer
Extract the nth word from a text string
VBA
0 vote293 views1 answer
Vba test optional argument
VBA
0 vote303 views1 answer
Excel named range sum
VBA
0 vote334 views1 answer
Winforms dark title bar
VBA
0 vote300 views1 answer
Vba array dimensions
VBA
2 votes272 views1 answer
Vba array contains
VBA
0 vote286 views1 answer
Vbnet find highest value in chart
VBA
0 vote292 views1 answer
Vba min
VBA
0 vote301 views1 answer
Vba static variable
VBA
0 vote294 views1 answer
Excel VBA web scraping
VBA