Gnatt Chart work Planne

[jonespandrew]

Hi There

I have created the attached planner/job board and require help in doing the following.

1. Under the days of the week. if a date range is entered i want it to auto colour the cells under days of the week.

2. in the engineer list section if i set and engineer to on holiday or sick, i want it to prevent you from selecting that engineer under the assigned engineers tab.

Can anyone please help with this.

How to I upload my file to this https://www.excelforum.com/attachme...t-work-planner-digital-job-board-planner.xlsx

 

[Peter_SSs]

How to I upload my file to this https://www.excelforum.com/attachme...t-work-planner-digital-job-board-planner.xlsx[/COLOR]

That requires users to be a member of that forum so they can log in.

My signature block below has a link with suggestions for how to post small screen shots directly in your post in this forum.