3 Questions on the "Employee Shift Scheduler" Template

Greetings,

I have 3 questions regarding the Employee Shift Scheduler found on the new template screen on excel.

1) How do you change the color template of the different position/time off to reflect on the "Employee Schedule" tab?

2) I need to have employee's have more than one position, and the only work around I found is creating multiple Employee's AKA Worker (Job1) Worker (Job2), is there a better way?

3) I need the Schedule to change color when a position is NOT covered on specific times that job needs covered. If job1 is from 8am-4pm, and jill and bob covered all hours of job1 except during 2-3pm, I would want that time frame to notify me when it is not covered. Any ideas on how to accomplish this?

Thanks for reading and really appreciate your knowledge on this guys!

Pai Mei

Capture.JPG

This is the shift schedule I was referring to!

Thanks