title: Conditional Formatting a Row based on cell value with Excel
body: <p>I have looked at multiple sites that show how to do Conditional Formatting in Excel for a row based on a cell value. But all of them use equations as there formula. For example, if cell value is 5, highlight the row blue. I am trying to do it with text. If cell value is "Completed", highlight the row green.</p>
  
  <p>This is the formula I was able to get from <a href="http://smallbusiness.chron.com/format-row-based-value-cell-excel-2007-40595.html" rel="nofollow">http://smallbusiness.chron.com/format-row-based-value-cell-excel-2007-40595.html</a></p>
  
  <pre><code>=INDIRECT("B"&amp;ROW())&gt;0
  </code></pre>
  
  <p>and modified it to </p>
  
  <pre><code>=INDIRECT("F"&amp;ROW())="Completed"
  </code></pre>
  
  <p>Basically I would like the row (from column A to F) to be highlighted Green if cell value in F (whichever row)=Completed.</p>