/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 vote218 views1 answer
Get current url vb.net
VBA
0 vote239 views1 answer
Vba keep command window open
VBA
0 vote218 views1 answer
Vbs exec hidden
VBA
0 vote260 views1 answer
Vbnet check if string is only numbers
VBA
0 vote247 views1 answer
Vba timestamp -- milliseconds
VBA
2 votes216 views1 answer
Excel vba date to string conversion
VBA
1 vote224 views1 answer
Excel vba Run a Macro every time sheet is changed
VBA
1 vote219 views1 answer
Excel vba get column name from number
VBA
0 vote226 views1 answer
Vba horizontalalignment
VBA
4 votes227 views2 answers
Excel vba last column with data
VBA