Re: Hintergrundfarbe
22.04.2003 14:46:38
ChrisL
Hallo HomerPrivate Sub Worksheet_Change(ByVal Target As Excel.Range)
If Target.Column >= 3 And Target.Column <= 39 And Target.Row >= 17 And Target.Row <= 83 And (Target.Row - 11) / 6 = WorksheetFunction.Round((Target.Row - 11) / 6, 0) Then
Target.Interior.ColorIndex = xlNone
If Target = "A" Then Target.Interior.ColorIndex = 3
If Target = "B" Then Target.Interior.ColorIndex = 4
If Target = "C" Then Target.Interior.ColorIndex = 5
If Target = "D" Then Target.Interior.ColorIndex = 6
If Target = "E" Then Target.Interior.ColorIndex = 7
End If
End Sub
Alt + F11, links Doppelklick auf Tabelle, neues Fenster öffnet sich, links oben Dropdown auf Worksheet ändern, rechts oben auf Change, Code einfügen, Fenster schliessen.
Gruss
Chris