Gantt conditional formatting to exclude weekends?

You need to do these things:
1. Move the 2 CF's with the MOD-function to the top of the list
2. Create a new CF with this this formula (make sure cell I7 is selected when entering the CF!)

Formula:

Please Login or Register  to view this content.

- Do not specify any format.
- Move the CF to the 3rd position of the list
- Mark it to Stop If True

Aha, in that case I think you can just change the formula of the CF you don't wont to be active for weekend days to this.

Formula:

Please Login or Register  to view this content.

You could do that for all the CF's you like.
Don't forget to remove the CF I suggested below again.

Tsjallie,

I'm so sorry, but I've now tried that and still no success. Could I impose upon you to ask that you show me in the spreadsheet how to fix it and upload?

thanks for your patience with me!

You're not alone in having trouble with CF. It's just pretty obscure.
And me being sloppy doesn't help either
Here's the workbook with the adjusted CF for Plan.

I've take out this CF-rule:
CF_Removed.JPG

And I've chnaged this one:
CF_Plan.JPG

Changed the formula to this:

Formula:

Please Login or Register  to view this content.

Yes, that's a somewhat other formula than I posted earlier. So I may well have contributed to your confusion. Sorry 'bout that.

Tsjallie,

Well, that's fixed the weekend shading issue, thanks!

Though now, in your example, only 8 days in total are shaded for a 10 day task..? I'd want to see 10 weekdays in blue cross hatching, ie. starting on 30/5, skipping weekend days and shading finishing on Mon 12/6.

See if the following will help.
1) Select cell I7 on the 'Daily' sheet,
2) From the Formulas tab select 'Name Manager',
3) Edit the 'PeriodInPlan' (the first one -- Scope 'Daily') so that it reads: =Daily!I$6=MEDIAN(Daily!I$6,Daily!$C7,WORKDAY(Daily!$C7,Daily!$D7)-1)
4) Select the close button,
5) When the pop up asks if you want to save the change select 'Yes'.
Let us know if you have any questions.

You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.

Unfortunately your post does not comply with Rule 4 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.