Sub misenforme()
Dim c As Range
Application.ScreenUpdating = False
For Each c In ActiveSheet.UsedRange
T = Date - c
Select Case T
Case 3
With c.Font
.ColorIndex = 3
.Bold = True
End With
Case 8
With c.Font
.ColorIndex = 46
.Bold = True
End With
End Select
Next c
End Sub