Formula Query for Staff Rota

Hi

I wonder if someone could help me. I have compiled a staff rota from a website tutorial but have personalised it so I can use at our care home using a series of drop down boxes for each shift on each cell. What I would like is that so not to put someone on a night shift then a day the next day Excel alerts me (comes up red etc) so I can amend it as no one can physically work a night shift then a day shift the next day! This is a common error when doing the rotas and this would be great if someone could provide a solution.

Rota attached.

Thanks in advance

Bigtiger

Hi, thanks for helping me with this. Unfortunately when I put in a night shift then a day the next day it doesn't come up red. On therota you kindly sent back there were two day shifts highlighted red instead ... or am I reading this wrong?

Regards

Bigtiger

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 :-)

Thank you so much. Just one slight thing, it also highlights red when I put in a day shift before a night shift. Its just the night before the day that needs to be highlighted red.

Thanks again

Bigtiger