It can be done. And it can be done a few ways. The first way would be to have a grand formula for each row in a cell. I don't think this is a good idea. Here is what the formula would look like for the first nine rules:

=IF(OR(O4=999,AD4=999), "1 ","")&IF(OR(Q4=999,AF4=999), "2 ","")&IF(OR(W4=99,AD4=99), "3 ","")&IF(OR(Y4=99,AF4=99), "4 ","")&IF(OR(AND(Q4>0,ISBLANK(O4)),AND(Y4>0,ISBLANK (W4)),AND(AF4>0,ISBLANK(AD4))), "5 ","")&IF(OR(AND(S4>0,OR(ISBLANK(O4),ISBLANK(Q4))), AND(AA4>0,OR(ISBLANK(W4),ISBLANK(Y4))),AND(AH4>0,O R(ISBLANK(AD4),ISBLANK(AF4)))), "6 ","")&IF(OR(AND(N4>0,ISBLANK(O4)),AND(P4>0,ISBLANK (Q4)),AND(R4>0,ISBLANK(S4)),AND(V4>0,ISBLANK(W4)), AND(X4>0,ISBLANK(Y4)),AND(Z4>0,ISBLANK(AA4)),AND(A C4>0,ISBLANK(AD4)),AND(AE4>0,ISBLANK(AF4)),AND(AG4 >0,ISBLANK(AH4))),"7 ","")&IF(OR(AND(O4>0,ISBLANK(N4)),AND(Q4>0,ISBLANK (P4)),AND(S4>0,ISBLANK(R4)),AND(W4>0,ISBLANK(V4)), AND(Y4>0,ISBLANK(X4)),AND(AA4>0,ISBLANK(Z4)),AND(A D4>0,ISBLANK(AC4)),AND(AF4>0,ISBLANK(AE4)),AND(AH4 >0,ISBLANK(AG4))),"8 ","")&IF(OR(AND(ISBLANK(O4)+ISBLANK(Q4)+ISBLANK(S4 )<2,OR(O4=Q4,O4=S4,Q4=S4)),AND(ISBLANK(W4)+ISBLANK (Y4)+ISBLANK(aa)<2,OR(W4=Y4,W4=AA4,Y4=AA4)),AND(IS BLANK(AD4)+ISBLANK(AF4)+ISBLANK(AH4)<2,OR(AD4=AF4, AD4=AH4,AF4=AH4))),"9 ","")

Although Excel has no problem handling such long equations, they are complicated and difficult to debug or even edit.

What I would suggest is to have a second tab that shows, as I posted before, the various errors in a table form for each row. Then on your main tab, the results of from the table can be combined into a single cell of results. This would make editing and debugging far easier.

You can have up to million rows. All you need to do is copy the formulas down.