Hi,
I have a table that we use to help schedule employees and want some type of warning if we double book them. It is setup as such:
<tbody>
</tbody>
I would like some type of conditional formatting or an alert box to pop up if someone is double booked. From this example John A is double booked from 7/2 - 7/5. So if it has the same name and >=2 entries on the same date I would like some type of warning. I know some vba if that would provide an easier solution.
Thanks!
I have a table that we use to help schedule employees and want some type of warning if we double book them. It is setup as such:
A | B | C | D | E | F | G | H | I | J | K | L | M | N | |
1 | Name | Job# | Loc | 6/25 | 6/26 | 6/27 | 6/28 | 6/29 | 6/30 | 7/1 | 7/2 | 7/3 | 7/4 | 7/5 |
2 | John A | X34 | USA | D | D | D | D | D | D | D | D | D | ||
3 | Joe | V45 | CAN | N | N | N | N | N | N | N | N | |||
4 | John A | V45 | CAN | D | D | D | D | |||||||
5 | Jen | X34 | USA | A | A | A | A | A | A | A | A |
<tbody>
</tbody>
I would like some type of conditional formatting or an alert box to pop up if someone is double booked. From this example John A is double booked from 7/2 - 7/5. So if it has the same name and >=2 entries on the same date I would like some type of warning. I know some vba if that would provide an easier solution.
Thanks!