Prøv denne, sletter celle farve til venstre for det markerde område, når der vælges "Delete" Dog også uden for område H3:H50
Private Sub Worksheet_Change(ByVal Target As Range)
On Error GoTo ErrHandler
Application.ScreenUpdating = False
ActiveSheet.Unprotect
If Not Application.Intersect(Target, Range("H3:H50")) Is Nothing Then
If Target = "" Then Range(Target.Offset(0, -7), Target.Offset(0, -2)).Interior.ColorIndex = xlColorIndexNone
If Target = "I proces" Then Range(Target.Offset(0, -7), Target.Offset(0, -2)).Interior.ColorIndex = 6
If Target = "Afvist" Then Range(Target.Offset(0, -7), Target.Offset(0, -2)).Interior.ColorIndex = 3
If Target = "Accept" Then Range(Target.Offset(0, -7), Target.Offset(0, -2)).Interior.ColorIndex = 4
End If
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
Application.ScreenUpdating = True
Exit Sub
ErrHandler:
Range(Target.Offset(0, -7), Target.Offset(0, -2)).Interior.ColorIndex = xlColorIndexNone
Application.ScreenUpdating = True
End Sub