LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
Posts: 9,221
Default auto-filter in excel but leave cell background color

No prob, Gord <g. Cheers
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Gord Dibben wrote:
Max

Thanks for posting.

I thought the =MOD(ROW(),2)=0 would stick through filtering, but my test data
was spurious......who woulda guessed?<g

Gord


 
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
Auto filter by background color. infinitodd New Users to Excel 2 March 31st 06 10:03 PM
Excel 2003 Font Color and Background Color DrankPA6 Excel Discussion (Misc queries) 1 August 12th 05 11:43 PM
Cell color based upon cell value My View Excel Discussion (Misc queries) 11 July 6th 05 03:59 AM
background color of my cell does not change Colorblinded Excel Discussion (Misc queries) 2 March 27th 05 04:55 PM
Excel Cell Background Colors Disappeared JerryI Excel Discussion (Misc queries) 6 March 24th 05 10:05 PM


All times are GMT +1. The time now is 10:52 AM.

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"