Gantt in Excel

[ferujade21]

Hi everyone,

can you please help me? I was trying to create a Gantt in Excel following this tutorial "

" but I can't make the formulas work.
here is a screenshot of my file:

I need to add two different formulas:
1. the first one to highlist where "today" is in the table. According to the video, the formula should be: =H$6=TODAY()-WEEKDAY(TODAY(), -2) + 1) but Excel says that's not a formula. Min 10.34 of the Youtube video.
2. second formula I'd like to add is the one for the Gantt bars.

What am I missing??
thank you,

 

[DanteAmor]

Hi and welcome to MrExcel.

Check the following thread, I think you can see the formulas and conditional formats there.

Excel conditional formatting in a Gantt Chart

I was trying to provide conditional formatting in my Gantt Chart. However, I have difficulty developing a formula that will trigger to highlight the cell or range, as the date is not a usual one. I'm hoping that someone from this group can help me solve the issue. I manually provided the colors...

www.mrexcel.com