Highlight weekends in stacked bar Gantt chart

nilaco

New Member
Joined
Dec 17, 2019
Messages
13
Office Version
  1. 365
Platform
  1. Windows
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!!

1624868810473.png
 

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.
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?
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,213,534
Messages
6,114,185
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top