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
|
If Cells(ligne, colonne).Value <> " " Then
ActiveSheet.Cells(ligne1, colonne).Select
Selection.Interior.ColorIndex = xlNone
If Cells(ligne1, colonne).Value = " " Then
Selection.Interior.ColorIndex = 15
End If
If Cells(ligne1, colonne).Value = "F" Then
Selection.Interior.ColorIndex = 24
End If
If Cells(ligne1, colonne).Value = "V" Then
Selection.Interior.ColorIndex = 40
End If
If Cells(ligne1, colonne).Value = "A" Then
Selection.Interior.ColorIndex = 34
End If
If Cells(ligne1, colonne).Value = "N" Then
Selection.Interior.ColorIndex = 0
End If
If Cells(ligne1, colonne).Value = "M" Then
Selection.Interior.ColorIndex = 27
End If
If Cells(ligne1, colonne).Value = "S" Then
Selection.Interior.ColorIndex = 33
End If
If Cells(ligne1, colonne).Value = "J" Then
Selection.Interior.ColorIndex = 16
End If |
Partager