Highlight weekends in stacked bar Gantt chart

[nilaco]

Hello!

I've created a dynamic Gantt chart in Excel (which I am quite proud of tbh!!). The only thing left that I need to do is highlight the weekends. I've tried following a couple of tutorials but I just can't seem to get it! Essentially, I'd like to get sat/sun highlighted in a light grey colour. Also if, for example, I need to extend the dates on the chart for a different project, the weekends would also need to automatically highlighted going forward. Please help, I'm tearig my hair out with this!!

 

[nilaco]

Actually, upon pondering this further, I think it would be better if I could exclude the weekends altogether. So when I put a task duration as 10 days, it means 10 working days/2 weeks. Does that make sense?

 

[ddander54]

I use Conditional Formatting (CF) to highlight the weekends in my gantt.

My CF formula is: =WEEKDAY(E$3,2)>5 where my dates start in column E and are in Row 3.
Applies to: Also starts in $E$3 and goes to $BO$31 or where ever the table data (bars) reside.

Bonus....
I also use this CF to highlight the current date....
=E$3=TODAY() , again where$E$3 starts the dates row in my gantt
I use a format that highlights the date in red and a red outline on the left and right side of each cell
Applies to: Also starts in $E$3 and goes to $BO$31 or where ever the table data (bars) reside.


Please attach a copy of your file if you need further assistance.

BTW: I agree, your gantt does look very nice!

Hope that helps,
Don