Alternate row shading and AutoFilter

Qing · Mar 20th, 2002, 04:03 AM

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 · Mar 20th, 2002, 05:41 AM

Hi Qing

Probably not without some very heavy VBA.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 20th, 2002, 04:03 AM	#1
Qing New Member Join Date: Mar 2002 Posts: 1	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

Mar 20th, 2002, 05:41 AM	#2
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Hi Qing Probably not without some very heavy VBA.