i am after setting up a pop up box when 2 conditions are met.
example- i have shift times on a worksheet ranging from 0700-1630 to 0930-1900.
a cell above the shift times can be changed to 8.5 if they want the holiday.
what i want is a pop up box to show if 8.5 is added to a 0930-1900 day so they know they need to cover their shift.
a b c d e
1 8.5 8.5
2 0700-1630 0700-1630 0700-1630 0700-1630 0700-1630
3 8.5
4 0930-1900 0930-1900 0930-1900 0930-1900 0930-1900
5
6 0800-1730 0800-1730 0800-1730 0800-1730 0800-1730
example- i have shift times on a worksheet ranging from 0700-1630 to 0930-1900.
a cell above the shift times can be changed to 8.5 if they want the holiday.
what i want is a pop up box to show if 8.5 is added to a 0930-1900 day so they know they need to cover their shift.
a b c d e
1 8.5 8.5
2 0700-1630 0700-1630 0700-1630 0700-1630 0700-1630
3 8.5
4 0930-1900 0930-1900 0930-1900 0930-1900 0930-1900
5
6 0800-1730 0800-1730 0800-1730 0800-1730 0800-1730