Forgive me but I do not understand what you mean. What my rota needs is, if I say put a night shift in on a Monday then a day shift on a Tuesday then that day shift would come up red to alert me that I cant put this person on these two shifts as they have just done a night shift. At the moment it is highlighted red only when I put in consecutive day shifts.

I hope that makes sense

Regards

Bigtiger :-)