title: Excel 2013 copy conditional formatting in all cells of a column rising
body: <p>I am working with Excel 2013. I need conditional formatting dependent on a condition: If cell L2 is not empty and cell <code>M2</code> is not empty format cell <code>D2</code> with background color.</p>
  
  <p>I tried <code>=AND($L2&gt;0,$M2&gt;0)</code> to apply to cell <code>D2</code> and it works fine.</p>
  
  <p>Now I want cell <code>D3</code> to get the rule <code>=AND($L3&gt;0,$M3&gt;0)</code>.</p>
  
  <p>I need that for hundreds of rows, so I don't want to make it by hand. So in the conditional format manager I added <code>Applies to =$D$2:$D$300</code>.</p>
  
  <p>But now suddenly all this cells have the new background color, even if both values of column <code>L</code> and column <code>M</code> of the same row are empty.</p>
  
  <p>Also using the format brush and selecting all cells in column <code>D</code> made them coloured.</p>
  
  <p>Where am I wrong here?</p>