/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 vote230 views1 answer
Excel vba disable alerts
VBA
5 votes231 views1 answer
Excel vba how to unit test vba code
VBA
0 vote247 views1 answer
Vbscript for loop
VBA
0 vote245 views1 answer
Vbnet chart make 0 gridline line different color
VBA
1 vote229 views1 answer
Vbscript convert ascii code to character
VBA
0 vote246 views1 answer
VBA is form loaded
VBA
0 vote237 views1 answer
Vba sort multiple columns
VBA
0 vote243 views1 answer
Excel text to columns line break
VBA
1 vote261 views1 answer
Find and replace textbox
VBA
0 vote234 views1 answer
Vbscript check if string contains
VBA