excel vba highlight cells using the hex color value within the cells

The solution for “excel vba highlight cells using the hex color value within the cells” can be found here. The following code will assist you in solving the problem.

‘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

Thank you for using DeclareCode; We hope you were able to resolve the issue.

More questions on [categories-list]

Similar Posts