/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

2 votes222 views1 answer
Vba ado ace sql alias ignored for calculated column
VBA
0 vote205 views1 answer
Vba file size
VBA
0 vote174 views10 answers
Vba excel create event log
VBA
0 vote240 views1 answer
Vba timestamp -- milliseconds
VBA
3 votes220 views1 answer
Excel vba change format of cell
VBA
0 vote294 views1 answer
Excel vba add reference programmatically
VBA
0 vote238 views1 answer
Vbnet chart make 0 gridline line different color
VBA
0 vote215 views1 answer
Excel vba range contains
VBA
31 votes473 views1 answer
Excel-vba how to convert a column number into an excel column
VBA
0 vote212 views1 answer
Send webhook vbscript
VBA