Excel - setting background color from RGB code

[dqrose]

In Excel, is there a way to set the background color of a cell from its RGB color code? For example, if cell A1 contains the hex value FF0000 (pure red) then I want the background color of that cell to be pure red.

Many thanks for any help

 

[SkipVought]

Hi,

With Activecell 
  .interior.color = .Value
End With

Skip,

_[red][/red]

 

[dqrose]

Hey - nice!

MANY thanks

 

[SkipVought]

Actually, this may be better in the Sheet Object Code Window...

Private Sub Worksheet_Change(ByVal Target As Range)
    With Target
        If .Value = "" Then Exit Sub
        If IsNumeric(.Value) Then _
            .Interior.Color = .Value
    End With
End Sub

Skip,

_[red][/red]

 

[dqrose]

Even better - once again, many thanks!