1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40
| Sub worksheet_change(ByVal target As Range)
If Not Intersect(target, Range("a1")) Is Nothing Then
On Error Resume Next
If Worksheets(1).Range.Value("a1") = "Vac" _
Then Worksheets(1).Range("a1:a3").Interior.ColorIndex = 1
If Worksheets(1).Range.Value("a1") = "For" _
Then Worksheets(1).Range("a1:a3").Interior.ColorIndex = 2
If Worksheets(1).Range.Value("a1") = "Pre" _
Then Worksheets(1).Range("a1:a3").Interior.ColorIndex = 3
If Worksheets(1).Range.Value("a1") = "Mal" _
Then Worksheets(1).Range("a1:a3").Interior.ColorIndex = 4
ElseIf Not Intersect(target, Range("b1")) Is Nothing Then
If Worksheets(1).Range.Value("b1") = "Vac" _
Then Worksheets(1).Range("b1:b3").Interior.ColorIndex = 1
If Worksheets(1).Range.Value("b1") = "For" _
Then Worksheets(1).Range("b1:b3").Interior.ColorIndex = 2
If Worksheets(1).Range.Value("b1") = "Pre" _
Then Worksheets(1).Range("b1:b3").Interior.ColorIndex = 3
If Worksheets(1).Range.Value("b1") = "Mal" _
Then Worksheets(1).Range("b1:b3").Interior.ColorIndex = 4
ElseIf Not Intersect(target, Range("c1")) Is Nothing Then
If Worksheets(1).Range.Value("c1") = "Vac" _
Then Worksheets(1).Range("c1:c3").Interior.ColorIndex = 1
If Worksheets(1).Range.Value("c1") = "For" _
Then Worksheets(1).Range("c1:c3").Interior.ColorIndex = 2
If Worksheets(1).Range.Value("c1") = "Pre" _
Then Worksheets(1).Range("c1:c3").Interior.ColorIndex = 3
If Worksheets(1).Range.Value("c1") = "Mal" _
Then Worksheets(1).Range("c1:c3").Interior.ColorIndex = 4
ElseIf Not Intersect(target, Range("d1")) Is Nothing Then
If Worksheets(1).Range.Value("d1") = "Vac" _
Then Worksheets(1).Range("d1:d3").Interior.ColorIndex = 1
If Worksheets(1).Range.Value("d1") = "For" _
Then Worksheets(1).Range("d1:d3").Interior.ColorIndex = 2
If Worksheets(1).Range.Value("d1") = "Pre" _
Then Worksheets(1).Range("d1:d3").Interior.ColorIndex = 3
If Worksheets(1).Range.Value("d1") = "Mal" _
Then Worksheets(1).Range("d1:d3").Interior.ColorIndex = 4
End If
End Sub |
Partager