Moving Cell Color

[Daver53]

Ok I'm very new to Excels functions. I am making a time sheet for Employees. In Column D I have a drop down Menu that they can select there type of charge from. There is 8 to select from. They each come up with a designated color.

What I would like is, in Column F they total there hours by that charge ID. I would like that cell (F) to match the color of what they selected in column (D).

Could anyone walk me through this?

Thanks in advance for any help.

 

[Puertorekinsam]

Copy this code

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 6 Then
Cells(Range(Target.Address).Row, 8).Interior.Color = Target.Interior.Color
End If
End Sub

in excel on the page you are using press alt+ f11

paste

 

[Daver53]

Im not having any luck