Sheets - Conditional formatting based on cell (date) in column based on dates in another column
<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>