I'm designing a shift roster and want to ensure person working in C shift (night shift) is not assigned shift A (morning shift) because it becomes a continous shift.
This means, if value of cell
B12 should be highligted as RED.
Take example below:
Col A Col B C A B C B B B B A B C A
It should throw me an error on the first and last cell of column B.