title: Highlight the row in excel mac 2011 when a cell has a specific word
body: <p>In Excel 2011 Mac (it seems to be important since other referenced solutions in stackoverflow for excel windows or mac older versions don't seem to work).</p>
  
  <p>I want to apply conditional formatting so when a cell in column D includes a word "student" the full row which includes the cell gets a color format (blue color for the text white/empty filling for the cell).</p>
  
  <p>I have tried INDIRECT and some other formulas but I don't get it right. Only the cell that includes the word gets the formatting, not the whole row (that is, the rest of the cells on the same row where the pattern matches).</p>