You have column headers with dates in steps of 7 days. Where do you expect to see a "date line"?
You can use conditional formatting to highlight a column if it is between two dates, e.g. between today() and today()-7 or between today() and today()+7
Your data does not readily present where to put the highlight. Please clarify.
Bookmarks