title: IF/AND between two dates Conditional Formatting
body: <p>I am trying to implement the following logic but my formulas are not encompassing all possibilities.  </p>
  
  <p>Am I able to accomplish the following using the approach outlined below?</p>
  
  <pre><code>C5 has a start date(yy/mm/dd), 2013-10-01.
  D5 has an end date(yy/mm/dd),2013-10-23.
  F3-&gt;CX2 has 7 cells merged with the monday's date in the cell.
  </code></pre>
  
  <p>Example: F3: <code>30-Sep-13</code>, M3: <code>07-Oct-13</code>, T3: <code>14-Oct-13</code>.</p>
  
  <p>F4->CX4 and below are the unmerged seven cells, therefore you have seven cells below each week cell.</p>
  
  <p>My goal is to use Conditional Formatting when cell has value TRUE to fill the background colour of each individual cell between the start and the end date. However I am having trouble determining the correct formula.  I have tried the following in F4 and across and below but none have proven to work for all scenario's:</p>
  
  <p><code>F4=AND(C5=F3, D5&gt;=F3)  F5=AND(C5=(F3+1), D5&gt;=(F3+1))...</code>  </p>
  
  <p>only fills the cell for the start date not all the cells between the start and end date.</p>
  
  <p>In short, I need to identify the start cell and fill it, continue filling all cells until the end date.  </p>
  
  <p>Should this be a macro with a while loop?  </p>
  
  <hr>
  
  <p>***I Believe I have solved my question with the following formula:</p>
  
  <p><code>=IF(AND((F3)&gt;=$C$5,(F3)&lt;=$D$5),TRUE,FALSE)</code>, <code>=IF(AND((F3+1)&gt;=$C$5,(F3+1)&lt;=$D$5),TRUE,FALSE)</code>, <code>=IF(AND((F3+2)&gt;=$C$5,(F3+2)&lt;=$D$5),TRUE,FALSE)</code>...Then after 7 cells it becomes: <code>=IF(AND((M3+1)&gt;=$C$5,(M3+1)&lt;=$D$5),TRUE,FALSE)</code>, <code>=IF(AND((M3+1)&gt;=$C$5,(M3+1)&lt;=$D$5),TRUE,FALSE)</code></p>