Cells(65000, 1).Value = ""
For Each cell In Range("c2:c100").Cells
If cell.Offset(0, -1).Value <= 6 And cell.Value >= 30 Then
MsgBox "ok"
cell.Interior.ColorIndex = 43
cell.Offset(0, -1).Interior.ColorIndex = 43
Cells(65000, 1).Value = "no"
End If
Next
If Cells(65000, 1).Value <> "no" Then
MsgBox "نعم كل الطلبة الناجحين اجتازوا ربع الدرجة"
Else
Exit Sub
End If