Excel Scroll Bar Control - Shift Current Value

[leen1234]

Hello, I added a scroll bar control on my excel file to add a gant chart. I would like to shift the current value my scroll bar is on based on today's date., I am using Excel 2013 Could anyone please help me.


Thank you

 

[padapinto]

add a formula with conditional format that high lights the current date in your chart