title: Colour a cell based on the length of time between that date cell and another date cell
body: <p><strong>This query is in relation to Google Sheets.</strong></p>
  
  <p>If the date in B1 is 10 days older than the date in A1, then B1 is shaded red.</p>
  
  <p>If the date in B1 is within 10 days of the date in A1, then B1 is shaded green.</p>
  
  <p>Does anyone know how I can do this please?</p>
  
  <p><strong>We hope to use this as follows:</strong></p>
  
  <ol>
  <li><p>Record the date we submit a product.</p></li>
  <li><p>Record a date to show we have detailed the product as suitable.<br>
  (We want this to be within 10 days of us initially submitting the product.)</p></li>
  </ol>
  
  <p>Therefore we submit a product on the date in A1</p>
  
  <p>We then detail the product as suitable and record this date in B1.</p>
  
  <p>If we have done this within 10 days, B1 should be green. If not, it should be red. This will help us deal with delays.</p>
  
  <p>Does anyone know how I can do this within Google Sheets please?</p>