Countif Function

  • Thread starter Thread starter Christine
  • Start date Start date
C

Christine

Does anyone know if it is possible to count the number of cells which meet 2
criteria, 1 being the date and the 2nd being a cell with text in red?

If so, how do I go about creating the formula?

I can provide more info if required.

Christine
 
try this

Sub CountRedDate()
mysum = 0
For Each c In [c9:c12]
If c.Value = [c7] _
And c.Font.ColorIndex = 46 Then _
mysum = mysum + 1
Next
MsgBox mysum
End Sub
 
Back
Top