Posted to microsoft.public.excel.programming

external usenet poster

Posts: 42

Conditional Format and auto filter

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Auto/conditional format	willemeulen	Excel Discussion (Misc queries)	0	May 6th 09 02:41 PM
DataFilterAuto Filter in excel 2007?	TIJ	New Users to Excel	2	November 13th 08 03:28 AM
ranging the filter cells when doing auto filter	thread	Excel Programming	8	April 25th 07 11:08 PM
can I use conditional format on an auto shape	Horse	Excel Discussion (Misc queries)	1	February 5th 07 01:44 PM
Excel auto filter doesn't recoginize case - won't filter AA from A	Mikey	Excel Discussion (Misc queries)	1	September 29th 05 08:18 PM

All times are GMT +1. The time now is 03:40 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us