You can use data validation if you want to something like this...
Highlight Cell C7.
Click Data|Validation - Custom
Add the formula
=NOT(OR(C7=C27, C7=C51))

Do the same for Cells C27 and C51 changing the appropriate cell references
to the formula. You may also want to change the error alert...
--
HTH...

Jim Thomlinson


"GIdunno" wrote:

I'm back with another problem :-)
I work a crew schedule; and I have 3 people who cannot work a shift
together. I need something that will NOT allow me to put them on a shift
together. We identify our shifts by D, S, or M (days, swings, mids) So I
cannot have Buck, Earle, or Small working a shift together. (weird rules
about these three)
I can't use conditional formatting for this because I already have used all
3 conditions for another issue.

Is there a way I can "raise a flag" if I schedule 2 or more of them on the
same shift?

Here's an idea of my schedule
Earle is in C7, Buck is in C27, and Small is in C51. If I were putting day
shift together in column D, then D7, D27, and/or D51 cannot match.

Any ideas O' Smart Excel people?