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 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101
|
Public Sub Couleur()
Dim iColumn As Integer
Dim iRow As Integer
Application.ScreenUpdating = False
ThisWorkbook.Worksheets("2018").Unprotect "2018"
For iRow = 20 To 138 'lignes de 20 à 138
Select Case iRow 'on fait un select sur iRow
Case 21, 22, 24, 25, 27, 28, 30, 31, 33, 34, 36, 37, 39, 40, 42, 43, 45, 46, 48, 49, 51, 52, 54, 55, 57, 58, 60, 61, 63, 64, 66, 67, 69, 70, 72, 73, 75, 76, 78, 79, 81, 82, 84, 85, 87, 88, 90, 91, 93, 94, 96, 97, 99, 100, 102, 103, 105, 106, 108, 109, 111, 112, 114, 115, 117, 118, 120, 121, 123, 124, 126, 127, 129, 130, 132, 133, 135, 136
GoTo flNextiRow 'on passe au flag flNextiRow
Case Else 'c'est mieux de mettre le case else, c'est pour toutes les autres lignes, mais on fait rien, donc le code continue
End Select
For iColumn = 27 To 758 'colonnes de AA(27) à ACD(758)
'Vide
If Cells(iRow, iColumn).Value = "" Then
'Cells(iRow, iColumn).Interior.Pattern = xlNone
Cells(iRow, iColumn).Font.Color = RGB(255, 255, 255)
Cells(iRow, iColumn).Interior.Color = RGB(255, 255, 255)
End If
'Jour
If Cells(iRow, iColumn).Value = "j" Then
Cells(iRow, iColumn).Font.Color = RGB(0, 0, 0)
Cells(iRow, iColumn).Interior.Color = RGB(0, 255, 0)
End If
'Nuit
If Cells(iRow, iColumn).Value = "n" Then
Cells(iRow, iColumn).Font.Color = RGB(255, 255, 255)
Cells(iRow, iColumn).Interior.Color = RGB(0, 0, 0)
End If
'Vacances
If Cells(iRow, iColumn).Value = "v" Then
Cells(iRow, iColumn).Font.Color = RGB(0, 0, 0)
Cells(iRow, iColumn).Interior.Color = RGB(255, 0, 255)
End If
'Vacances Travail
If Cells(iRow, iColumn).Value = "vt" Then
Cells(iRow, iColumn).Font.Color = RGB(0, 0, 0)
Cells(iRow, iColumn).Interior.Color = RGB(255, 0, 255)
End If
'Maladie
If Cells(iRow, iColumn).Value = "m" Then
Cells(iRow, iColumn).Font.Color = RGB(0, 0, 0)
Cells(iRow, iColumn).Interior.Color = RGB(0, 255, 255)
End If
'Congé
If Cells(iRow, iColumn).Value = "c" Then
Cells(iRow, iColumn).Font.Color = RGB(0, 0, 0)
Cells(iRow, iColumn).Interior.Color = RGB(247, 150, 70)
End If
'Congé statutaire
If Cells(iRow, iColumn).Value = "cs" Then
Cells(iRow, iColumn).Font.Color = RGB(0, 0, 0)
Cells(iRow, iColumn).Interior.Color = RGB(247, 150, 70)
End If
'Congé férié
If Cells(iRow, iColumn).Value = "cf" Then
Cells(iRow, iColumn).Font.Color = RGB(0, 0, 0)
Cells(iRow, iColumn).Interior.Color = RGB(247, 150, 70)
End If
'Congé Réserve
If Cells(iRow, iColumn).Value = "cr" Then
Cells(iRow, iColumn).Font.Color = RGB(0, 0, 0)
Cells(iRow, iColumn).Interior.Color = RGB(250, 191, 143)
End If
'Instruction
If Cells(iRow, iColumn).Value = "i" Then
Cells(iRow, iColumn).Font.Color = RGB(255, 255, 255)
Cells(iRow, iColumn).Interior.Color = RGB(83, 141, 213)
End If
'Ecole
If Cells(iRow, iColumn).Value = "e" Then
Cells(iRow, iColumn).Font.Color = RGB(255, 255, 255)
Cells(iRow, iColumn).Interior.Color = RGB(0, 0, 255)
End If
'Reserve 1
If Cells(iRow, iColumn).Value = "r1" Then
Cells(iRow, iColumn).Font.Color = RGB(0, 0, 0)
Cells(iRow, iColumn).Interior.Color = RGB(255, 255, 153)
End If
'Reserve2
If Cells(iRow, iColumn).Value = "r2" Then
Cells(iRow, iColumn).Font.Color = RGB(0, 0, 0)
Cells(iRow, iColumn).Interior.Color = RGB(255, 255, 153)
End If
'Reserve 3
If Cells(iRow, iColumn).Value = "r3" Then
Cells(iRow, iColumn).Font.Color = RGB(0, 0, 0)
Cells(iRow, iColumn).Interior.Color = RGB(255, 255, 153)
End If
Next iColumn
flNextiRow:
Next iRow
ThisWorkbook.Worksheets("2018").Protect "2018"
End Sub |
Partager