title: Conditional formatting dates older than
body: <p>I want to setup conditional formatting on the entire column F. Dates that are one year old or older should be red.</p>
  
  <p>I have selected the entire column and tried these two formulas in the formatting rule:</p>
  
  <pre><code>=$F:$F&lt;=NOW()-365
  </code></pre>
  
  <p>and</p>
  
  <pre><code>=$F:$F&lt;=TODAY()-365
  </code></pre>
  
  <p>Can't get dates in January 2014 to turn red. I have the column formatted as Date (dd-mm-yyyy).</p>