I have a list of sales people and invoices for which they are responsible. Some have more than one invoice, so I don't want to alternate row color at every row, I want to alternate colors at every change in sales person.
I used this thread to build the alternating color: thread401-1563045
In the thread, @blom0344 warns "The tricky bit is to make sure that the running-count(1) index is in the same order as the data displayed in the list (otherwise the alternating fails)"
Well, the alternating is failing for me. How do I make sure the index is in the same order?
Example (where row = 1 has line formatting):
Row Name Invoice
0 Beck 123
1 Boise 5435
1 Casalls 4324
1 Casalls 99
0 Frapp 9010
0 Morgan 44
1 Smith 342
1 Trapp 832
0 Ziet 238
I want it to display like this:
Row Name Invoice
0 Beck 123
1 Boise 5435
0 Casalls 4324
0 Casalls 99
1 Frapp 9010
0 Morgan 44
1 Smith 342
0 Trapp 832
1 Ziet 238
TIA.
I used this thread to build the alternating color: thread401-1563045
In the thread, @blom0344 warns "The tricky bit is to make sure that the running-count(1) index is in the same order as the data displayed in the list (otherwise the alternating fails)"
Well, the alternating is failing for me. How do I make sure the index is in the same order?
Example (where row = 1 has line formatting):
Row Name Invoice
0 Beck 123
1 Boise 5435
1 Casalls 4324
1 Casalls 99
0 Frapp 9010
0 Morgan 44
1 Smith 342
1 Trapp 832
0 Ziet 238
I want it to display like this:
Row Name Invoice
0 Beck 123
1 Boise 5435
0 Casalls 4324
0 Casalls 99
1 Frapp 9010
0 Morgan 44
1 Smith 342
0 Trapp 832
1 Ziet 238
TIA.