title: Conditional formatting a table cell based based another table cell for project start end dates
body: <p>I am trying to build a project planning doc that automatically highlights the month cells based on the start and end dates of the project.</p>
  
  <p>Currently I have entered the formula in the cell... But, I would like the formula to be embedded in the conditional formatting command itself so that I can have other info on the cell...</p>
  
  <pre><code>START   END Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
  
  3/5/2014    9/15/2014
  </code></pre>
  
  <p>Currently I am using the below formula in the cell. Instead I would like to have this formula embedded in the conditional formatting as a formula to highlight the respective cell.</p>
  
  <pre><code>C2 = IF(AND($C$1&lt;=$B2,$A2&lt;$D$1),"Overlap","Do not overlap")
  D2 = IF(AND($D$1&lt;=$B2,$A2&lt;$E$1),"Overlap","Do not overlap")
  </code></pre>