title: Excel: Highlighting a whole column depending on date
body: <p>I have made my own Gantt chart in Excel, which is shown in this picture:</p>
  
  <p><img src="https://i.stack.imgur.com/UtSDK.png" alt="http://i.imgur.com/ECNEAOW.png">. </p>
  
  <p>I would like to highlight the whole column (or until the last activity) depending on the date, as shown in the picture. I figured out how to highlight a single cell depending on the date, but not a whole column. </p>
  
  <p>I don't know how to do it short of entering the date into the whole column, but I thought there would be something more efficient if conditional formatting is used.</p>