'entités qui n'ont pas de Fréquence Maj renseignee: mise en rouge
lastrow = ActiveSheet.UsedRange.SpecialCells(xlCellTypeLastCell).Row
With Sheets("Feuil1")
For i = 1 To lastrow
If .Cells(i, 12).Value = "" And .Cells(i, 8).Value = "Client" Then
With .Cells(i, 12).EntireRow
.Interior.ColorIndex = 3
End With
End If
Next i
End With
'comparaison des date limite avec la date du jour
With Sheets("Feuil1")
For i = 2 To lastrow
If .Cells(i, 8).Value = "Client" And .Cells(i, 13) < Now() Then
With .Cells(i, 14).EntireRow
.Interior.ColorIndex = 6
End With
End If
Next i
End With