title: Excel conditional formatting to change entire row color
body: <p>I have excel sheet which collect some numbers for each day. At end of each month I have row which will sum all numbers and show as an overview.date is in dd/mm/yyyy format on all cell except the one which shows the overview,
  example:
  Column A          Column B</p>
  
  <pre><code>1/01/2016           20
  2/01/2016           1000
  .
  .
  .
  .
  .
  31/01/2016           10
  Jan-2016            1030
  </code></pre>
  
  <p>As you can see after the last date in Jan it will create a row to show overview of the jan and it will continue for all month. I need to highlight the row which has overview using different background color.</p>
  
  <p>I am able to highlight the Column A (where it will show Jan-2016 and so on) using below conditional formatting formula</p>
  
  <pre><code>=SUM(COUNTIF(A2,$L$1:$L$12&amp;"*"))
  </code></pre>
  
  <p>where L1 to L12 contains text : Jan, Feb, Mar .... Dec</p>
  
  <p>But I am unable to find a way to highlight entire row instead of first cell in that cell.</p>
  
  <p>Any idea here to achieve this ?</p>