I use =MOD(ROW(),2)=1 to shade every other row in my worksheet.

When auto filter is used it will not keep every other row shaded. Often
shaded rows are together.

Is there a more flexible way so that auto filter will not affect the
shading. It looks strange when a sheet is printed.

Hank