title: How to highlight area from start to end date in Excel using VBA?
body: <p>I have start and end dates given in Columns A and B. Then I choose a range which I want to look at  and generate a row of dates which starts from C1 and can end at any point. I need to highlight a row from start date to end date to the right of given dates. Is there a way to do this? I have no idea where to start...Help, please.
  For Example,</p>
  
  <p>I want to look at range from 5/2/2015 to 5/5/2015
  Instead of zeros i need this area to be highlighted.</p>
  
  <pre><code>   A          B        C         D        E         F      G
  1 start     end      5/2/2015 5/3/2015 5/3/2015 5/4/2015 5/52015
  2 5/1/2015  5/3/2015 00000000000000000
  3 5/2/2015  5/2/2015 00000000
  4 5/4/2015  5/5/2015                            0000000000000000
  </code></pre>