/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

11 votes290 views1 answer
Excel vba How to URL encode a string
VBA
0 vote227 views2 answers
Get excel file from email attachment in vba
VBA
1 vote223 views1 answer
Add a index column power bi
VBA
0 vote222 views1 answer
Select case vba
VBA
5 votes238 views1 answer
Xl vba double quotes in string literal
VBA
22 votes354 views1 answer
Xl vba check for folder
VBA
0 vote232 views1 answer
Get month number from month name vbnet
VBA
1 vote251 views1 answer
Excel vba get column number from column name
VBA
0 vote232 views1 answer
Vba remove numbers from string
VBA
8 votes234 views1 answer
Run command pormpt in background windows
VBA