Google #Sheet alternating range based on cell value

gsheets_alternate_color_range.txt

# Example for 'banding' value in column A2+

# Format, Conditional formatting:
Custom Formula
Apply to range: A2:U50
Formula: =ISODD(MATCH($A2, UNIQUE($A$2:$A2),0))


# ArrayFormula:
={"gg";ARRAYFORMULA(
ISODD(MATCH($A2:$A100
         , UNIQUE($A2:$A100)
         ,0) )
)}