Row colouring that accommodates filtering?

[StargateFanFromWork]

What can be used instead of "=MOD(ROW(),2)=1" that accommodates filtering,
pls?

The above gives clumps of identically-coloured rows, dependent on the
particular filter criteria used.

Thank you! D

 

[T. Valko]

As long as there are no empty cells within the filtered list:

Assume A1:B1 is the header row.

A2:B10 is the data

Select the range A2:B10
Conditional Formatting
Formula Is: =MOD(SUBTOTAL(3,$A1:$A$2),2)=0

Biff