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
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