/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

3 votes218 views1 answer
Vba not equal
VBA
0 vote247 views1 answer
Check if cell is dbnullvb.net
VBA
0 vote209 views1 answer
Vbscript abs
VBA
0 vote246 views1 answer
Vb ternary
VBA
0 vote210 views2 answers
How to update date and time automatically once id is entered in excel vba
VBA
0 vote203 views1 answer
Faire appel à la mise en forme conditionnelle vba excel
VBA
0 vote211 views1 answer
Vba file chooser
VBA
0 vote216 views1 answer
Openfiledialog specific folder
VBA
1 vote217 views1 answer
Add rows to datagridview vb.net
VBA
0 vote170 views1 answer
Vba code to remove leading and trailing spaces
VBA