/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 vote170 views1 answer
Excel vba last column in range
VBA
0 vote177 views1 answer
Excel vba linter
VBA
0 vote185 views1 answer
VBA OR vb6 find OR replace string from the end
VBA
-1 vote177 views1 answer
Vba code to add new column in table
VBA
5 votes194 views1 answer
Excel-vba get integer high byte
VBA
3 votes225 views2 answers
Excel "vba" match last value
VBA
4 votes173 views1 answer
Vba create directory
VBA
0 vote177 views1 answer
Ribbon show/hide
VBA
1 vote184 views1 answer
Vb.net get name by Selection Changed
VBA
0 vote174 views1 answer
Limit combobox to list vba
VBA