Shift Work Calendar Year at Glance Template

To add more shifts in Shift Pattern insert new rows for them and add shifts with their unique codes

Next modify Shift Pattern string, i.e. in above: 3 days shift D, one day-off, 2 days shift N, two days off, two days shift S, etc.

Next in Name Manager add names for these shift codes, here are Shift4_Code and Shift5_Code

Next in calendar Conditional Formatting duplicate rule for day formatting

edit formula and change name of the code at the end of formula. Fill with proper color. Result as in attached.