How do I change the colors in a column of cells automatically when I open a worksheet

Hello,

I am in the process of creating a spreadsheet based on a project gantt chart without using an actual chart. So far I have gotten the cells to change color based on start & end dates and changed the color based on weekends and holidays but I can't seem to get the colors in the cells to highlight from one day to the next based on today's date.
I want to create a function that will highlight the cells in the column if they relate to today's date (this will change when the sheet us opened each day). I have seen this used in other charts but I do not know if this can be done with an IF, AND, or ? statement or if I have to get into more difficult formulas? Any help would be greatly appreciated

Thanks

Barb

Here is the spreadsheet that I am working on

Thanks - that worked

Can you help me with the other part of my problem listed in the spreadsheet pertaining to the scroll bar?

It is added using the developer tab - insert scroll bar

I actually figured it out - I had to format the value based on a 1 year scroll (365 days) that revolved around a project start date.