Dim AdrCell As String
Dim nb_lig As Long
Dim nb_col As Integer
...
...
...
AdrCell = Cells(nb_lig + 2, nb_col - 1).Address
Selection.FormatConditions.Delete
Selection.FormatConditions.Add Type:=xlCellValue, Operator:=xlGreater, _
Formula1:='=' & AdrCell
Selection.FormatConditions(1).Interior.ColorIndex = 3