title: Multiple conditions in Excel conditional formatting
body: <p>I'm fairly new to Excel and so not very experienced, but I'm trying to get an entire row to highlight red based on 2 other cells, using conditional formatting. The requirements are for the corresponding M cell in the row to have the value 'N' and for the corresponding E cell to have a past date value '&lt;*NOW'.</p>
  
  <p>I've tried a formula based on an answer for multiple conditions:</p>
  
  <p>=AND(M="(N)";E&lt;*NOW)</p>
  
  <p>A formula for formatting an entire row:</p>
  
  <p>=INDIRECT("m"&amp;ROW())="N",("e"&amp;ROW())E&lt;*NOW</p>
  
  <p>And combining the two:</p>
  
  <p>=AND=INDIRECT("m"&amp;ROW())="N",=INDIRECT("e"&amp;ROW())E&lt;*NOW)</p>
  
  <p>(ignore all the asterisks its the only way i could get the NOW to appear)</p>
  
  <p>None of these are working, please help!</p>