Formula or Conditional Formatting for Double Booking Staff on Gantt chart
Please find screenshot of the Sheet attached.
I would like to achieve one of the two options below preferably the first!
If one of the staff members is booked for the same day on multiple jobs to;
- Highlight both jobs and the fields which are causing the problem or;
- To give a red symbol in the "Valid" column
Can someone help me with either a formula or a way of adding this in conditional formatting?
Thanks in advance
Help Article Resources
Check out the Formula Handbook template!