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
| Range("K" & Target.Row & ":Q" & Target.Row).ClearContents
Target = "X"
For i = 11 To 56 Step 3
If Range("K" & i).Value = "X" Then
Cells(i, 1).Interior.Color = RGB(9, 255, 56)
Cells(i, 1).Interior.Color = RGB(9, 255, 56)
ElseIf Range("M" & i).Value = "X" Then
Cells(i, 1).Interior.Color = RGB(125, 255, 150)
Cells(i, 1).Interior.Color = RGB(125, 255, 150)
ElseIf Range("O" & i).Value = "X" Then
Cells(i, 1).Interior.Color = RGB(255, 133, 133)
Cells(i, 1).Interior.Color = RGB(255, 133, 133)
ElseIf Range("Q" & i).Value = "X" Then
Cells(i, 1).Interior.Color = RGB(255, 29, 29)
Cells(i, 1).Interior.Color = RGB(255, 29, 29)
End If
Next
End Sub |
Partager