+ Reply to Thread
Results 1 to 3 of 3

Conditional Formatting - shading weekends

  1. #1
    Registered User
    Join Date
    04-07-2011
    Location
    Brooklyn, Michigan
    MS-Off Ver
    Excel 2007
    Posts
    21

    Conditional Formatting - shading weekends

    Greetings!

    I'm trying to figure out a few conditional format formulas, and am not having any luck. I have attached a model spreadsheet for how I would like it to work/look, and have included the following notes:

    1 What is the formula to shade Saturday & Sunday (& holidays) gray, as I've done in May)
    2 What is the formula to shade SET UP BEGIN to SET UP FINISH yellow?
    3 What is the formula to shade RUN DATE to ENDING DATE green?
    After building this spreadsheet, I can see now that I need to break down my ghant chart showing a month per tab, instead of all on one tab like I have it. But, but for right now, I figured I had better get the formatting worked out before proceeding.

    As always, the people in this forum are amazing - thank you, in advance, for any help you can offer.

    Jenn Bates

    IR Schedule.xlsx

  2. #2
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,578

    Re: Conditional Formatting - shading weekends

    Select your range V3:KJ13
    Green
    =AND(V$3>=$Q4,V$3<=$R4,COUNT($Q4:$R4)=2)
    Yellow
    =AND(V$3>=$O4, V$3<=$P4,COUNT($O4:$P4)=2)
    Gray
    =WEEKDAY(V$3,2)>5
    Does that work for you?
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  3. #3
    Registered User
    Join Date
    04-07-2011
    Location
    Brooklyn, Michigan
    MS-Off Ver
    Excel 2007
    Posts
    21

    Re: Conditional Formatting - shading weekends

    It works perfectly - thank you SO much!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1