Make it so that my boss can't put me and my coworker on night shift together.

I've got a coworker who i dread working night shift with. The boss uses excel to make the work schedule. Is there any way to make it so he can't put us on night shift together? Like linking the two rows so only one of them can have information in them per column. Not something that would throw out a huge error, maybe just something that would clear my cell if he fills in the coworker's cell for the night shift on the same day. Something that makes him pause and try to find someone else to put on the night shift.