rows alternating colors, no table including filter

[perrush]

Hi All,

I would like to have a table where the rows have alternating colors, but without the use of table formatting (because it slows the excel too much down). AND after filtering the rows should still have alternating colors for the visible rows.

The last part is what I'm struggling with.

tia
Stefan

 

[Peter_SSs]

See if this helps

 

[perrush]

tnx very much, works like a charm

 

[Peter_SSs]

tnx very much, works like a charm

You're welcome. Glad it suited your purpose.