#1
|
|||
|
|||
Maximum number of working days reached= warning color
Hi all!
Im trying to create a warning function in a simple scheduling sheet I made for staffing planning. The sheet containts a two-week schedule. If a particular day contains time, then it gets the value "1", if no time "0". What I want to do is to make Excel react if the two-week schedule contains more than 6 days in row, in any given combination (for example week 1 maybe only have 2 work days, saturday and sunday, but then week 2 continues with +5 work days). So one of the obstacles is the 2-week loop. My goal is that IF the two-week schedule contains more days in a row than allowed, the affected days should turn yellow by conditional formatting. I consider myself pretty good at Excel but this one keeps me sleepless kind regards Joakim |
#2
|
||||
|
||||
How's the worksheet arranged, perZZon? It's not a VBA solution, but I think I can see a way to do it. You may have to adapt it, though, depending on how your dates are arranged. See the attached example.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do I get auto-updated "number of days since specified date" on MS word? | terry795 | Word | 16 | 01-07-2016 04:33 PM |
Maximum Number Of Styles-Based-On? | Pluviophile | Word | 13 | 05-08-2014 05:29 AM |
Converting serial number to years, months and days | hannu | Excel | 6 | 02-14-2013 09:21 PM |
Master Projects with different Working Days | Philip.Skeet | Project | 2 | 08-19-2011 09:45 AM |
Non-Working Days on Gantt | JayTT | Project | 1 | 01-28-2011 05:42 AM |