Public Sub Format_Ligne(feuille As String, ByVal lig As Integer, dbcol As Integer, fncol As Integer)
With Worksheets(feuille)
With .Range(.Cells(lig, dbcol), .Cells(lig, fncol))
.Borders.LineStyle = 1
.Borders.Weight = xlMedium
.Borders.Color = RGB(230, 230, 230)
.SpecialCells(xlLastCell).Borders(xlEdgeRight).Color = RGB(89, 89, 89)
.Borders(xlEdgeBottom).Color = RGB(89, 89, 89)
.Interior.Color = Array(RGB(232, 232, 232), RGB(209, 209, 209))(Abs(lig Mod 2 <> 0))
End With
End With
End Sub