Share via

Conditional formatting to identify weekends in gantt chart

Anonymous
2013-12-05T16:44:33+00:00

Hello.

I've created a gantt chart in excel with calendar dates across the top of the spreadsheet.  I would like to use conditional formatting to highlight the weekends only (the entire column).  Would anyone be able to assist me with this question?

 

Thanks so much for your time.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

7 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2013-12-05T17:00:23+00:00

    use the equation

    =WEEKDAY(A$1)

    This will give you a number for what day of the week it is, so something like

    =OR(WEEKDAY(A$1) =6,WEEKDAY(A$1) =7)

    play around with it to make sure you are using the correct weekend numbers, I seem to recall that may be a machine-specific setting, so you may (rarely) come across someone who has adjusted that and their columns would not be colored correctly.

    Replacing A$1 with the actual row of the dates and column of interest.

    0 comments
  2. Anonymous
    2013-12-05T17:04:54+00:00

    Hi,

    Use this CF formula

    =WEEKDAY(A5,2)>5

    0 comments
  3. Anonymous
    2013-12-05T17:51:16+00:00

    Hello Keith -

    Thanks so much for replying to my question.  Your formula below did work for most of the spreadsheet but for some reason it stopped working as I added the remaining dates to the conditional formatting.

    Note:  It worked for all columns up to "FW".  Afterwards, the formatting began to highlight 3 rows versus 2 (see columns "GC-GE" below.

    Any idea why this is happening?

    0 comments
  4. Anonymous
    2013-12-05T19:59:37+00:00

    Hi,

    select the desired range say, A6:AE15

    and write this formula (in CF)

    =OR(WEEKDAY(A$6)=1,WEEKDAY(A$6)=7)

    0 comments