Given data like:
How can I conditionally color blocks based upon having the same contiguous value in the 2nd column?
Alternating is fine.
In the case above:
The 1st 3 rows would be one color, 3 columns wide
This would change to a different color for rows 4 and 5.
Finally, there would be another transition, moving into the 6th row.
Code:
A 1 Z
C 1 Y
L 1 X
R 2 W
S 2 V
T 3 U
How can I conditionally color blocks based upon having the same contiguous value in the 2nd column?
Alternating is fine.
In the case above:
The 1st 3 rows would be one color, 3 columns wide
This would change to a different color for rows 4 and 5.
Finally, there would be another transition, moving into the 6th row.