Sub Coloriage()
Dim objCollabos As Object, Col1 As Range, ChampCible As Range, NbLignes As Long, NbColonnes As Long, i%, j%, wkCollabos As Worksheet, wkProd As Worksheet, Combo1$, Combo2$, Combo3$, Combo4$
Set wkCollabos = ThisWorkbook.Worksheets("BDD Fiches de Formation")
Set objCollabos = wkCollabos.ListObjects("_Collaborateurs")
Set wkProd =...