Alternsti
03-28-2015, 04:16 PM
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 ?
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 ?