title: How display text in a cell if the value of the cell next to it is above, below, or equal to 50%
body: <p>I have been searching for a formula that will allow me to do what should be a simple conditional format.</p>
  
  <p>I have a list of students and beside each name is a column that calculates the grade in recent exams. If this grade is 50% or higher I would like the cell beside it to display "Pass", otherwise it should display "Fail" by default.</p>
  
  <p>I just can't seem to find any information on how to do this.</p>
  
  <p>I'm using Excel 2010.</p>
  
  <p>Thanks</p>