/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

5 votes817 views1 answer
Vlookup vba
VBA
0 vote311 views1 answer
Iterate all file in a folder vba
VBA
0 vote300 views4 answers
How to continue formula in below line in vba code
VBA
3 votes290 views2 answers
Excel "vba" match last value
VBA
0 vote298 views1 answer
Find control with name vb
VBA
0 vote292 views1 answer
Limit combobox to list vba
VBA
8 votes355 views1 answer
Excel vba determine number of elements in a 2D array
VBA
0 vote328 views1 answer
Visual basic run command
VBA
0 vote297 views1 answer
Vba excel do not recalculate before save
VBA
0 vote301 views1 answer
Find if year is leap year vb
VBA