Highlighting with a Calendar created

[OX_2005]

So I am not sure if what I am trying to do is possible. But here goes. I have 2 teams that every other week they work Sun, Mon, Tues. of one week and the next every other week they work Sun, Mon, Tues. I have a calendar created and what I am trying to do is if in column "C" it says Team 1 or 3 it will highlight the days they do not work that week. Is what I am looking to do even possible?

 

[OX_2005]

OK, forget all that and try conditional formatting

for Teams 1 & 2
=OR(AND(MOD(VALUE(E$8)-45354,14)>=3, MOD(VALUE(E$8)-45354,14)<=6), AND(MOD(VALUE(E$8)-45354,14)>=11, MOD(VALUE(E$8)-45354,14)<=13))

for Team 3
=OR(AND(MOD(VALUE(E$8)-45354,14)>=0, MOD(VALUE(E$8)-45354,14)<=2), AND(MOD(VALUE(E$8)-45354,14)>=7, MOD(VALUE(E$8)-45354,14)<=10))

 

[OX_2005]

It looks like that is working perfectly. I just added 1 small tweak to the formula. only because we run with around 7 crews but those 3 are the only ones on a 4 on/3 off then 3 on/4 off

Teams 1 & 2
=IF(OR($C10="Team 1",$C10="Team 2"),OR(AND(MOD(VALUE(E$8)-45354,14)>=3, MOD(VALUE(E$8)-45354,14)<=6), AND(MOD(VALUE(E$8)-45354,14)>=11, MOD(VALUE(E$8)-45354,14)<=13)),"")

Team 3
=IF($C10="Team 3",OR(AND(MOD(VALUE(E$8)-45354,14)>=0, MOD(VALUE(E$8)-45354,14)<=2), AND(MOD(VALUE(E$8)-45354,14)>=7, MOD(VALUE(E$8)-45354,14)<=10)),"")

 

[NoSparks]

I'm sure the macro would work if I had put it in the Worksheet_Change event, monitoring the month in J4, and including a line to clear current highlighting but that was an oversight on my part.

Anyway, glad I could help in getting something workable.
Good luck with the rest of your project.

 

[OX_2005]

Thank you again for your help ion this