So let's say I have a spreadsheet in which the values in the first column go like so:

> 
> 1
> 
> 
> 1
> 
> 
> 1
> 
> 
> 2
> 
> 
> 2
> 
> 
> 4
> 
> 
> 4
> 
> 
> 6
> 
> 
> 

I want to highlight every other grouping of values. Meaning the first 3 rows, all containing 1, would be highlighted one color. Then the 2s would have no fill. Then the rows containing 4 in the first column would be highlighted the same color as the first block.

Essentially, I want to alternate fill/no fill every time the value in the first column changes. These values are not necessarily numeric, so if a new column is needed with transposed numeric values, please let me know.

Thanks for checking out my question. If clarification is needed, do not hesitate to ask.