jonespandrew
New Member
- Joined
- Oct 8, 2015
- Messages
- 49
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
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
Last edited: