Alternate row shading and AutoFilter

[Qing]

Hello,

It is not difficult to make an alternate row shading with conditional formatting (=MOD(ROW(),2)=0). This formatting is preserved when rows are added or deleted. That is nice. But when AutoFilter is applied and some rows are hidden, this does not work. Is there a way to preserve an alternate row shading in this case?

Qing

 

[Dave Hawley]

Hi Qing

Probably not without some very heavy VBA.