Bonjour DANVAL, le forum,
Un essai....je me suis contenté de rajouter la condition "CARTE"....
'Vérification voiture et dates
Sheets("VOITURE reservation").Select
derlig = Range("C" & Rows.Count).End(xlUp).Row
For i = 3 To derlig
If Cells(i, 3) <> "" And Cells(i, 18) <> "" And Cells(i, 19) <> "" Then
voiture = Cells(i, 3)
debut = CLng(Cells(i, 18))
fin = CLng(Cells(i, 19))
carte = Cells(i, 20)
'Coloriage planning
Sheets("config").Select
dlig = Range("B" & Rows.Count).End(xlUp).Row
For j = 3 To dlig
If Range("B" & j) = voiture Then
For k = 3 To 733
If DateValue(Cells(2, k)) >= debut And DateValue(Cells(2, k)) <= fin Then
If carte = "CARTE" Then
Cells(j, k) = "CARTE"
Else
Cells(j, k) = ""
End If
Cells(j, k).Interior.Color = RGB(0, 204, 255)
End If
Next k
End If
Next j
Cordialement,