Does anyone know how to create a formula that causes the row colour to alternate when using conditional formatting?
Use Format -> Conditional Formatting with two conditions with these formulas:
Format -> Conditional Formatting
then apply your custom format.
4 years ago