title: MS (Project) Find Strings in text10 and change font color
body: <p>I'm changing the color of font in MS Project based on Percentage complete and Names in text10 column.  The percentages work however can someone give me a steer on the names I would be grateful, I want to highlight in teal if for example "David" or "Darren" or both are in <code>Text10</code> field. </p>
  
  <p>Any help gratefully received. </p>
  
  <pre><code>Sub text()
  
  Dim Ctr As Integer
  
  ViewApply "Gantt Chart"
  OutlineShowAllTasks
  FilterApply "All Tasks"
  SelectAll
  
  For Ctr = 1 To ActiveSelection.Tasks.Count
      SelectRow Row:=Ctr, rowrelative:=False
      If Not ActiveSelection.Tasks(1) Is Nothing Then
          If ActiveSelection.Tasks(1).Text10 = ("David") &amp; ("Darren") Then
              Font Color:=pjTeal
          Else
              If ActiveSelection.Tasks(1).PercentComplete = 100 Then
                  Font Color:=pjGreen
              Else
                  If ActiveSelection.Tasks(1).PercentComplete = 0 Then
                      Font Color:=pjBlack
                  Else
                      If ActiveSelection.Tasks(1).PercentComplete &gt; 0 &lt; 100 Then
                          Font Color:=pjBlue
                      Else
                      End If
                  End If
              End If
          End If
      End If
  Next Ctr
  
  End Sub
  </code></pre>