+ Reply to Thread
Results 1 to 7 of 7

Conditional formatting on certain days of the week

  1. #1
    Registered User
    Join Date
    08-12-2010
    Location
    Slovenia, Budanje
    MS-Off Ver
    Excel 2003
    Posts
    12

    Conditional formatting on certain days of the week

    Hi!

    I wonder if it is possible to set conditional formatting to apply automaticlly on certain days of the week. I am making a shift schedule for work and I would like to achive cells to become red if a shift is understaffed. On weekends I dont need as many workers as I do on weekdays. Will I need to set conditional formatting manually for each month (weekends are on other dates...) or is there a way to do this automatiaclly.

    Regards,

    Marko

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: Conditional formatting on certain days of the week

    You can use conditional formatting to do this automatically.

    If you post your workbook and show which cells you wish to be red then we can show you how.

    BSB

  3. #3
    Registered User
    Join Date
    08-12-2010
    Location
    Slovenia, Budanje
    MS-Off Ver
    Excel 2003
    Posts
    12

    Re: Conditional formatting on certain days of the week

    This is the file. Line 32 counts how many workers works "D" (morning shift). Line 34 line counts "P" (afternoon shift). I wold like to set letters or background to red if the number is different than 4 during week days and 2 in the weekend. I do know haw to set conditional formatting manually (picking the cells by myself). But how to do this automatically?

    Regards,

    Marko
    Attached Files Attached Files

  4. #4
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: Conditional formatting on certain days of the week

    Can I just clarify that as the data stands right now all of the cells in row 32 and 34 should be red as none of them have 4 or greater on weekdays or 2 or greater on weekends?

    BSB

  5. #5
    Registered User
    Join Date
    08-12-2010
    Location
    Slovenia, Budanje
    MS-Off Ver
    Excel 2003
    Posts
    12
    That is because I didn't fill in the schedule yet. The numbers will rise when I do.

    Regards

  6. #6
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: Conditional formatting on certain days of the week

    See if the attached does what you need.

    I've used the below formula for conditional formatting.
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    BSB
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    08-12-2010
    Location
    Slovenia, Budanje
    MS-Off Ver
    Excel 2003
    Posts
    12

    Re: Conditional formatting on certain days of the week

    Thank you you have helped me greatly. I broke your formula in 2 different conditional formatting and it works like a charm

    Regards,

    Marko

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 2
    Last Post: 10-03-2016, 08:35 AM
  2. [SOLVED] Highlight week number using Conditional formatting - shows incorrect week
    By spliffter in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 02-26-2016, 09:52 AM
  3. Replies: 2
    Last Post: 01-03-2015, 04:42 PM
  4. Conditional formatting based on text ( week days)
    By gfmout in forum Excel General
    Replies: 4
    Last Post: 12-16-2013, 03:34 PM
  5. Conditional formatting cell colors for the 7 days of the week
    By damianberry in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-19-2013, 02:51 AM
  6. Conditional Formatting Days of the Week
    By braydon16 in forum Excel General
    Replies: 3
    Last Post: 01-13-2011, 03:43 PM
  7. conditional formatting/days of the week
    By ki_cz in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-04-2008, 05:29 AM

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