Array (25rows x 6 colomns) to be filled with random numbers with rules

[Alternsti]

Hi,

I'm stick with rules. Every numbers must be generated using random.

Master rule: Each row must have only one one columns selected
1st column must have 3 cells selected
2nd column must have 3 pairs or cell selected
3rd column must have 3 cells selected (one of the them must have a specific text)
4th column must have 3 cells selected
5th column must have 3 cells selected
6th column will highlight unselected cells

Shall I use conditional formatting in VBA ?

[snb]

I don't think it matters which method you use.