Sub MAJ_MFC()
Application.ScreenUpdating = False
Cells.FormatConditions.Delete 'RAZ
With [A1].CurrentRegion
If .Rows.Count <= 3 Or .Columns.Count <= 2 Then Exit Sub
With .Cells(3, 2).Resize(.Rows.Count - 3, .Columns.Count - 2) 'à partir de B3
.FormatConditions.Add xlExpression, Formula1:="=B3="""""
.FormatConditions(1).Interior.ColorIndex = 16 'gris
.Cells(1, .Columns.Count + 3) = "=MOD(B3,2)=1" 'pour obtenir la formule sous toute version
.FormatConditions.Add xlExpression, Formula1:=.Cells(1, .Columns.Count + 3).FormulaLocal
.FormatConditions(2).Interior.ColorIndex = 46 'orange
.Cells(1, .Columns.Count + 3) = "=SUMPRODUCT(MOD(" & .Columns(1).Address(1, 0) & ",2))=0"
.Rows(0).FormatConditions.Add xlExpression, Formula1:=.Cells(1, .Columns.Count + 3).FormulaLocal 'en ligne 2
.Rows(0).FormatConditions(1).Interior.ColorIndex = 4 'vert
.Cells(1, .Columns.Count + 3) = ""
End With
End With
End Sub