/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 vote161 views10 answers
Vba excel create event log
VBA
0 vote220 views2 answers
S yyyy-MM-dd em vb net
VBA
0 vote201 views1 answer
Vba shape transparent
VBA
-1 vote220 views1 answer
Code for reading letters only in vb 6
VBA
0 vote212 views1 answer
Excel vba copy range with filter
VBA
0 vote196 views1 answer
Excel vba remove formatting from cell
VBA
5 votes231 views1 answer
Excel vba how to unit test vba code
VBA
8 votes268 views1 answer
Excel vba make word
VBA
0 vote256 views1 answer
Visual basic cmd
VBA
0 vote198 views1 answer
Excel vba select multiple shapes
VBA