title: Excel - Conditional Formatting - Updates Based on Current Date
body: <p>How would I go about applying conditional formatting to a range of cells (Excel 2007) based on the current date?</p>
  
  <p>I have a six-week plan (each column represents a day in the week (Monday to Friday, excluduing weekends)) and I would like to shade each column in green as the day passes without any user interaction, so that when I look at it, it will accurately have 'marked off' each day.</p>
  
  <p>This is what I hope to achieve: I view the plan on Monday 1st January.  I then don't access it until Thursday 4th January; once the plan is opened, I will see that the columns M-W have been shaded in green, whereas the rest of the plan for the remainder of the six weeks remains unshaded and this should continue for the remainder of the duration of the six-week plan.</p>
  
  <p>Is this possible?</p>
  
  <p>I would imagine that VBA would be used to check the system time and then apply the formatting according to what day it is.</p>
  
  <p>Many thanks.</p>
  
  <p><strong>UPDATE</strong></p>
  
  <p>This is how my planner looks:</p>
  
  <p><img src="https://i.stack.imgur.com/WQZJw.png" alt="Planner"></p>