Here's what I came up with. I did convert all those text "numbers" to numbers so if they must remain text, you will have to modify the CF formulas accordingly. That will add quite a bit of complexity to them so I recommend rather that you convert.
To give you an idea just how complex they are already, this is the one that checks if the same code and hours exist twice...
=AND(ISBLANK($N$13)+ISBLANK($P$13)+ISBLANK($R$13)< 2,OR(AND($N$13=$P$13,$O$13=$Q$13),AND($N$13=$R$1,$ O$13=$S$13),AND($R$13=$P$13,$S$13=$Q$13)))
First, it checks to make sure there are fewer than 2 blank code/hours. Thus if there are two blanks, it will not highlight them.
Next it compares 1/2, 1/3, and 2/3 and if any of them are have both code and hours the same, it will highlight.
|