LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 26
Default Zebra stripe format filtered case as well

Hi,

I learned in "msexcelraj website (could not see a name to mention here to
thank)" how to make zebra stripe formating:
Conditional formating, mod(row(),2)=0).
My additional question is "how can I have zebra appearence when I make
filtering as well ?" When I filter, naturally zebra appearence is losing with
the way above.

Thanks and regards,

Cousin Excel
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Stripe out duplicate data Gotroots Excel Worksheet Functions 5 December 8th 09 12:10 PM
Format cell to convert to Upper case widman Excel Discussion (Misc queries) 4 June 3rd 08 08:29 PM
What happened to the stripe fills for data series in Excel 2007? kittytrax Charts and Charting in Excel 1 April 18th 07 11:52 AM
Format Case for only Deepak Excel Discussion (Misc queries) 1 November 25th 06 10:38 AM
Upper Case and date format issue Andy Tallent Excel Discussion (Misc queries) 3 April 8th 05 04:52 AM


All times are GMT +1. The time now is 04:11 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"