Maximum number of working days reached= warning color

[perZZon]

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

[BobBridges]

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.