Option Explicit
'
Sub Etude()
Dim cell As Range
Dim Compteur As Variant, Red As Variant
'
Compteur = 0
For Each cell In Sheets("Page1").Range("B3:B20").Cells
If cell <> "" Then Compteur = Compteur + 1
Next
'
Red = 0
'
For Each cell In Sheets("Page1").Range("C3:C" & Compteur + 2).Cells
If cell.Font.ColorIndex = 3 Or cell.Offset(0, 1).Font.ColorIndex = 3 Or cell.Offset(0, 2).Font.ColorIndex = 3 Then
Red = Red + 1
End If
Next
Sheets("Page1").Range("G5").Value = Compteur
Sheets("Page1").Range("G8").Value = Red
'
End Sub