Susie0112
New Member
- Joined
- Jun 17, 2015
- Messages
- 1
Hello all!
I researched other CF questions but didn't see one that would answer my question.
I am using 2013 Excel and trying to figure out a formula that would color code a work calendar according to teams, ie: blue team vs gold team work days. Blue team will work four days in a row. Both teams work on every other Friday. Gold team works four days then blue team comes back for five days. Gold works four days, both work Friday then blue works for four.
The pattern of days is - 4:1:4:5.
Is there a way to do this through Excel? We've been color coding manually but I'm convinced there is an easier way.
Thank you in advance!
I researched other CF questions but didn't see one that would answer my question.
I am using 2013 Excel and trying to figure out a formula that would color code a work calendar according to teams, ie: blue team vs gold team work days. Blue team will work four days in a row. Both teams work on every other Friday. Gold team works four days then blue team comes back for five days. Gold works four days, both work Friday then blue works for four.
The pattern of days is - 4:1:4:5.
Is there a way to do this through Excel? We've been color coding manually but I'm convinced there is an easier way.
Thank you in advance!