Set a Cell background colour with hex value from another cell

[Excelerate3305]

This is my very first post so please be gentle. I was wondering if it is possible to set the background colour of a cell with a hex value that I would enter from an adjacent cell?? I suspect some form of VBA code will be required?

 

[Marc L]

directly without HexToRGB

Private Sub Worksheet_Change(ByVal Target As Range)
        Dim V
    With Target(1)
        If .Column = 10 And .Row > 7 Then
            V = Application.Hex2Dec(.Text):  If IsError(V) Then V = vbWhite
            Target(1, 2).Interior.Color = IIf(.Text = "", vbWhite, V)
        End If
    End With
End Sub