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: 21
Default how do i sort formated (colour) field in excel?



"Eric" wrote:

I have formated a few colour in some columns in a excel file, I trying to
sort these gorup of formated field data in group by using sorting comand in
stead of cut & paste each of them. Is that any body can help me?



Up to Excel 2oo3 (I don´t know whether this is true for Excel 2oo7) There is
no way to sort by colour.

However, "Primitive Software" distributes a "Special Sort" software that let
you sort by font- and cell colour. It works excellently.

Contact or use their website

http://www.realezsites.com/bus/primitivesoftware/
 
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
Include ability to sort Excel cells by colour Ian Johnston Excel Worksheet Functions 1 June 29th 06 12:36 PM
use if function if field is highlighted in colour in excel kirkyringo Excel Discussion (Misc queries) 2 January 29th 06 10:28 AM
Excel should let me sort by colour kbatey25 Excel Worksheet Functions 1 September 9th 05 11:34 AM
sort by colour Gers Excel Discussion (Misc queries) 1 April 2nd 05 02:08 AM
Sort by Colour? FBxiii Excel Worksheet Functions 3 November 8th 04 04:01 PM


All times are GMT +1. The time now is 09:48 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"