title: VBA to find the font color of a string
body: <p>I am new to VBA..I am writing a macro for some file comparison..My requirement is if a string has red color font,that string should be ignored for iteration and code should move to next iteration..I have tried the following code.</p>
  
  <pre><code>Dim compare = {"test1","test2","test3",.....etc}
  
  i=0
  
  For j=1 to Ubound(compare)    
    j=1
  
    If compare.Characters(j,Len(compare(i))).Font.Color &lt;&gt; vbRed Then    
      ' Some Code
    End If
  
    i=i+1    
  Next
  </code></pre>
  
  <p>However during the execution I am getting runtime error 424 "Object Required.Please help me to complete this task</p>
  
  <p>Thanks in advance.</p>