title: How to count up text of a different font colour in excel
body: <p>I have a list of names that has been exported from another database into excel. The names in the list that are of interest are highlighted in red font. I would like a way to count it, i.e. John Smith appears 5 times in total in a column but 3 of the 5 times, his name comes up highlighted in red font. So I would like to see how many instances of his name comes up red.</p>
  
  <p>I know How to search all instances of his name e.g. =COUNTIF(A1:A100,"John Smith ")</p>
  
  <p>I've also had help in creating a VB function which counts all values that are red (=SumRed) (once the colour index is specified) in a worksheet by using this:</p>
  
  <pre><code>Function SumRed(MyRange As Range)
      SumRed = 0
  For Each cell In MyRange
      If cell.Font.Color = 255 Then
          SumRed = SumRed + cell.Value
      End If
  Next cell
  End Function
  </code></pre>
  
  <p>I just can't find a way to combine the two counting conditions. Any help would be much appreciated!</p>