Row colouring that accommodates filtering?

  • Thread starter Thread starter StargateFanFromWork
  • Start date Start date
S

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! :oD
 
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
 
Back
Top