Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Oct 2008
    Posts
    17
    Thanks
    0
    Thanked 0 Times in 0 Posts

    leave out sundays (Excel 2003)

    In the attached spreadsheet I would like to exclude Sundays and the Saturdays row to be formatted in maroon automatically - how could I achieve this?
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: leave out sundays (Excel 2003)

    Welcome to Woody's Lounge!

    The workbook that you attached contains lots of sheets. Which one is your question about, and what exactly do you mean by "exclude Sundays"?

  3. #3
    New Lounger
    Join Date
    Oct 2008
    Posts
    17
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: leave out sundays (Excel 2003)

    Sorry about that. I am only working with Sheet one at this stage. I want to insert the start date at a3 and then which then fills the rest of the dates using the formula I have created. However I dont want to include Sundays as no one has to work on that day.

    Hope that makes sense.
    Attached Files Attached Files

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: leave out sundays (Excel 2003)

    Try this formula in A4:

    =A3+1+(WEEKDAY(A3)=7)

    and fill down.

    Next, select the range in which you want to apply conditional formatting (A333). Cell A3 should be the active cell within the selection.
    Set the fill color to 'No Fill' and the text color to Automatic.
    Select Format | Conditional Formatting...
    Select 'Formula Is' from the first dropdown.
    Enter the following formula in the box next to it:

    =WEEKDAY($A3)=7

    Click Format..., and set the text color to white and the fill color (in the Pattern tab) to maroon.
    Click OK twice.

  5. #5
    New Lounger
    Join Date
    Oct 2008
    Posts
    17
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: leave out sundays (Excel 2003)

    Thankyou so much. This is great. It worked.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •