Posted to microsoft.public.excel.misc

excel public misc

Posts: n/a

color banding in Excel after sorting

FOUND IT!! for thos looking for the same it's here...

http://groups.google.ca/group/micros...8224784462fa9c
wrote:
I'm trying to color band this list for item numbers (alternate color
bands for each change in item number), but can only find simple color
band formulas such as this on the web
http://www.cpearson.com/excel/banding.htm Any idea how to do this with
conditional formatting? Thanks for the help

Item Info
1 a
1 b
1 c
1 d
2 e
2 f
2 g
2 h
3 I
3 j
3 k
3 l
3 m

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
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ???	Richard	Excel Discussion (Misc queries)	2	May 13th 23 11:46 AM
Sorting Columns on HTML file created in Excel	Terri and Rob	Excel Discussion (Misc queries)	2	December 4th 05 03:06 AM
Sorting of data in excel 2003	jonpdavies	Excel Discussion (Misc queries)	3	November 23rd 05 03:24 PM
In Excel, sorting columns automatically by clicking column title	Destiny	Excel Discussion (Misc queries)	1	June 23rd 05 06:39 PM
Difference in number of Excel NewsGroups	Hari Prasadh	Excel Discussion (Misc queries)	1	January 25th 05 11:32 AM

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

About Us

"It's about Microsoft Excel"