Color set of rows according to sort.

[Ph0ny]

So, I have this sheet and VBA code.

Code look like this:

Please Login or Register  to view this content.

You can see what this VBA will do. I want to be able to color ever second SET of rows that match according to column F. Every second time the value in the F column change I want to color it. How to do it?

See example:

A B C D E F
1 2 3 4 5 6
1 2 3 4 5 6
7 8 9 0 1 2
7 8 9 0 1 2
3 4 5 6 7 8
3 4 5 6 7 8
3 4 5 6 7 8
9 0 1 2 3 4
9 0 1 2 3 4

[Ph0ny]

Ill try to explain in psedu-code.

IF cell above =< then SET selected color red

[Ph0ny]

what I would like to do, bit I cant get it to work.

http://www.dailydoseofexcel.com/arch...color-banding/