Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / October 2006

Tip: Looking for answers? Try searching our database.

EXcel 2007 - Unable to sort by font and cell colors

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Mr. Low - 28 Oct 2006 05:32 GMT
Dear Sir,

I have tested the MS Excel 2007 (Beta2) on color sorting today.

I find that this function is partially successful. It is unable to group the
items of the same color on top or at the bottom witthout an error row above
it. Frequently the first row is an error with font or cell with other color
appeared after sorting.  Items with other colors were not group together.

May I know if this is due to a flaw in the program or is there another way
of doing it ? < I used Data , Sort, by color, color apprear first selection>

May I suggest to MS for a new feature of grouping cell or font of the same
color together as this is very useful for our daily office work.

Eg: Before Sorting
RED
BLUE
GREEN
YEOLOW
RED
GREEN
BLUE
RED
YELLOW

After Sorting
RED
RED
RED
YELLOW
YELLOW
GREEN
GREEN
BLUE
BLUE

Thanks

Low

Signature

A36B58K641

Dave F - 28 Oct 2006 15:49 GMT
The MSFT developers for XL 2007 don't seem to regularly read this
discussion group.  If you have a question for them I suggest that you
email them directly via their blog:
http://www.google.com/url?sa=t&ct=res&cd=1&url=http%3A%2F%2Fblogs.msdn.com%2Fexc
el%2F&ei=1m1DReH2B47QwQKdyvj5CQ&usg=__CMA_gwW8M_z2DBkq4jPwSnnEu-0=&sig2=HyuuPc0s
pXTyzkMJzPq1wQ

Dave

> Dear Sir,
>
[quoted text clipped - 36 lines]
>
> Low
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.