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