title: Get Specific Text in a Range of Excel cells using C#
body: <p>I am working in WPF application with excel . In that application i am having a column name as Bulk. That column contains two options like YES and NO as a text. Now i need to indicate the font as red color for YES option and Normal Black color for NO option.
          I got the range of that particular column. But i dont know How shall i get the YES options and NO options seperately and also i need to color that options as per the need.</p>
  
  <p>Here I mentioned my code :</p>
  
  <pre><code>foreach(Range Value in range.cells)
  {
  
  ???????
  ???????
  }
  </code></pre>
  
  <p>Any one pls tell me the solution of this. How shall i proceed this process. Thanks in Advance.</p>