title: Conditional formatting on block of cells using once cell value and then copying multiple times
body: <p>Hoping I can get some help with this.</p>
  
  <p>I need to apply conditional formatting to a block of cells (E21:F27) based on one cell value condition (E23>0), which I can do. I then need to copy this 'block' multiple times across, which I've managed to do too - using 2 conditional format rules:</p>
  
  <p><a href="http://i.stack.imgur.com/9hR8e.jpg" rel="nofollow">Conditional Formats</a></p>
  
  <p><a href="http://i.stack.imgur.com/QDsFp.jpg" rel="nofollow">Rows to be copied</a></p>
  
  <p>I now want to copy &amp; paste rows 21-27 and have the conditional formats update the row numbers automatically.</p>
  
  <p>If this possible? I have googled my little heart out but can't find anything on it...</p>
  
  <p>Your help is much appreciated!!! :)</p>