/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 vote300 views1 answer
Vba format currency
VBA
0 vote302 views1 answer
Open application from vbnet
VBA
0 vote325 views1 answer
Vba excel do not recalculate before save
VBA
0 vote334 views1 answer
Excel vba protect sheet
VBA
1 vote307 views1 answer
Excel vba last row of range
VBA
0 vote339 views1 answer
Excel vba unlock sheet without password
VBA
0 vote298 views1 answer
Do until vb.net
VBA
0 vote320 views1 answer
Vba timestamp -- milliseconds
VBA
0 vote306 views1 answer
Set column width of datagridview vb.net
VBA
5 votes359 views1 answer
Excel vba get user selected range
VBA