Results 1 to 9 of 9
  1. #1
    5 Star Lounger
    Join Date
    Aug 2001
    Location
    Surrey, United Kingdom
    Posts
    1,001
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Conditional Formatting query (2003 SP2)

    Good afternoon

    I have been playing around with Custom numbers in cells and have discovered that if I put ddd_dd_mmmm_yy I get something like Tue 1 Jan 08 etc.

    In a workbook I have certain columns of dates that are all filled in from the value in D6, therefore if D6 is entered as 01/01/08 it shows Tue 1 Jan 08 and the following 30 cells follow on from there ie. Wed 2 Jan 08 etc.

    Is it possible now that the cells can show what days are weekends that I can have another cell coloured by Conditional Formating, ie. IF='Weekend', if so what is the actual formula to show in Conditional Formatting

    Cheers

    Steve
    Cheers

    Steve

    Asking the questions everbody wants the answers too but feels too stupid to ask themselves :-)

  2. #2
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Conditional Formatting query (2003 SP2)

    Afternoon Steve

    Try

    =WEEKDAY(A1,2)>5

    and format the CF as you wish
    Jerry

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

    Re: Conditional Formatting query (2003 SP2)

    Select the cells. I'll assume that D6 is the active cell within the selection.
    Select Format | Conditional Formatting...
    Select Formula Is from the first dropdown list.
    Enter the following formula in the box next to it:
    <code>
    =WEEKDAY(D6,2)>5
    </code>
    Click Format...
    Specify the formatting you want.
    OK your way out.

  4. #4
    5 Star Lounger
    Join Date
    Aug 2001
    Location
    Surrey, United Kingdom
    Posts
    1,001
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Conditional Formatting query (2003 SP2)

    Thanks Jerry and Hans

    I read through loads of old posts and thought I had to substitute weekday for weekend

    Cheers

    Steve
    Cheers

    Steve

    Asking the questions everbody wants the answers too but feels too stupid to ask themselves :-)

  5. #5
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Conditional Formatting query (2003 SP2)

    I'd substitute a weekday for the weekend anytime <img src=/S/laugh.gif border=0 alt=laugh width=15 height=15>
    Jerry

  6. #6
    5 Star Lounger
    Join Date
    Aug 2001
    Location
    Surrey, United Kingdom
    Posts
    1,001
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Conditional Formatting query (2003 SP2)

    Not today though, I can only see about 25 feet away, the fog (sorry Rudi, heavy mist <img src=/S/smile.gif border=0 alt=smile width=15 height=15> ) it is very thick and getting thicker by the minute, I live about 10- 15 minute walk from T4 at Heathrow in a village called Stanwell and I have not heard a plane today. I tried to take a photo with the all singing and dancing Kodak digital camera I got for my birthday last weekend but the smallest I can get the picture is 750kb at the moment.

    Steve
    Cheers

    Steve

    Asking the questions everbody wants the answers too but feels too stupid to ask themselves :-)

  7. #7
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Conditional Formatting query (2003 SP2)

    Maybe the picture of the very thick mist will look something like this?
    Attached Images Attached Images
    Regards,
    Rudi

  8. #8
    5 Star Lounger
    Join Date
    Aug 2001
    Location
    Surrey, United Kingdom
    Posts
    1,001
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Conditional Formatting query (2003 SP2)

    Hi Rudi

    Thats very close, I had to go out but have come back and have managed to reduce the size, it is actuallly much worse than this now
    Attached Images Attached Images
    Cheers

    Steve

    Asking the questions everbody wants the answers too but feels too stupid to ask themselves :-)

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

    Re: Conditional Formatting query (2003 SP2)

    I don't think there's a WEEKEND function in Excel... <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

Posting Permissions

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