Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Not Intersect(Target(1), Range("T5:T50")) Is Nothing Then
Range("T5:T50").Interior.ColorIndex = xlNone
Target(1).Interior.Color = 7700479
End If
End Sub
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
'Cells.Interior.ColorIndex = xlNone einblenden, wenn doch nicht nix gemacht werden soll...
Set bereich = Application.Intersect(Range("T5:T50"), Target)
If Not bereich Is Nothing Then Target.Interior.ColorIndex = 22
End Sub