title: Sheets - Conditional formatting based on cell (date) in column based on dates in another column
body: <p>New to sheets so would appreciate any assistance, unable to find appropriate guidance so far online.</p>
  
  <p>I want to conditional format cells in one column based on the dates in another - and repeat the conditional formatting down all rows. 
  I.E </p>
  
  <pre><code>Column A            Column B              Column C  
  Date submitted      Target                Actual   
  10/10/16            10/17/16(Col.A+7)     10/15/16   
  </code></pre>
  
  <p>I want to format column B (target date) based on content of column C (actual date). If actual date is:</p>
  
  <ul>
  <li>on or before target - conditional format cell green, </li>
  <li>after target date - conditional format cell red.</li>
  <li>blank - no conditional format</li>
  </ul>
  
  <p>I then want to ensure the same rule applies to all rows individually, without the condition being driven from the first row. Each row will be separate non-related items for date tracking.</p>
  
  <p>Thanks in advance.</p>