=ANNEE(AUJOURDHUI())+1
Sub test()
Dim Cellule As Range, Formule As String
For Each Cellule In Selection
Formule = Cellule.FormatConditions(1).Formula1
Formule = Replace(Formule, "2011", "ANNEE(AUJOURDHUI())+1")
Cellule.FormatConditions(1).Modify xlCellValue, xlLess, Formule
Next
End Sub
Sub test()
Dim Cellule As Range, Formule As String
For Each Cellule In Selection
Formule = Cellule.FormatConditions(1).Formula1
Formule = Replace(Replace(Formule, "2010", "ANNEE(AUJOURDHUI())+1"), "=", "")
Cellule.FormatConditions(1).Modify xlCellValue, xlEqual, Formule
Next
End Sub
Sub test()
Dim Cellule As Range, Formule As String
For Each Cellule In Selection
Formule = Cellule.FormatConditions(3).Formula1
Formule = Replace(Formule, "2010", "ANNEE(AUJOURDHUI())+1")
Cellule.FormatConditions(3).Modify xlExpression, xlEqual, Formule
Next
End Sub