Sub couleurs_noms()
Dim j As Long, k As Long
Application.ScreenUpdating = False
With Sheets("Planning")
For j = 11 To 10000
For k = 10 To 34
If .Cells(j, 1) = "" And .Cells(j, 2) = "" Then Exit Sub
If .Cells(j, 2) = "Fabrice FONTAINE" And .Cells(j, k).Interior.ColorIndex <> xlNone Then
.Cells(j, 2).Font.ColorIndex = 5
.Cells(j, k).Interior.ColorIndex = 5
ElseIf .Cells(j, 2) = "Stéphane POCHET" And .Cells(j, k).Interior.ColorIndex <> xlNone Then
.Cells(j, 2).Font.ColorIndex = 44
.Cells(j, k).Interior.ColorIndex = 44
ElseIf .Cells(j, 2) = "Christophe ANSELIN" And .Cells(j, k).Interior.ColorIndex <> xlNone Then
.Cells(j, 2).Font.ColorIndex = 4
.Cells(j, k).Interior.ColorIndex = 4
ElseIf .Cells(j, 2) = "Isabelle POCHET" And .Cells(j, k).Interior.ColorIndex <> xlNone Then
.Cells(j, 2).Font.ColorIndex = 7
.Cells(j, k).Interior.ColorIndex = 7
ElseIf .Cells(j, 2) = "Françoise GALLET" And .Cells(j, k).Interior.ColorIndex <> xlNone Then
.Cells(j, 2).Font.ColorIndex = 46
.Cells(j, k).Interior.ColorIndex = 46
ElseIf .Cells(j, 2) = "Didier MARQUOIS" And .Cells(j, k).Interior.ColorIndex <> xlNone Then
.Cells(j, 2).Font.ColorIndex = 29
.Cells(j, k).Interior.ColorIndex = 29
End If
Next k
Next j
End With
Application.ScreenUpdating = True
End Sub