1.JPG
2.JPG

I have 4 categories and Cat (Cell R1) is to be entered by the client from 1 to 4.
After client has keyed in (eg:1), I will have to insert a formula in U6 that will check O6 to T6 for the condition

No more than 2C, only 1R.
If it's true return 1, false return 0. (at U6)

If client enters in Cat 2.
I will have to check O6 to T6 for no more than 2D, only 1R.
If it's true return 1, false return 0.