Mobile menu

Sorting Excel sheet by cell colours
Thread poster: Csaba Ban

Csaba Ban  Identity Verified
Hungary
Local time: 04:24
Member (2002)
English to Hungarian
+ ...
Jul 9, 2003

I have a sizeable Excel sheet (around 3000 rows), where each row is either painted yellow, green or pink. The yellow and green rows contain strings already translated (thus good raw material for building a terminology / translation database), whereas the pink rows are translatable (only source segment available).

Is there any easy (or not-so-easy but still feasible) of sorting the rows in this sheet according to cell colour and in the end reinstaling the original row sequence?

I can manage with macros, but I am afraid I would need Visual Basic here, which is beyond my competence.

Any useful ideas will be appreciated.


Direct link Reply with quote
 

Csaba Ban  Identity Verified
Hungary
Local time: 04:24
Member (2002)
English to Hungarian
+ ...
TOPIC STARTER
Got the answer Jul 9, 2003

For future reference, for anyone who might need to do the same thing:
http://www.cpearson.com/excel/SortByColor.htm

I still have to understand it though


Direct link Reply with quote
 
Robert Zawadzki  Identity Verified
Local time: 04:24
English to Polish
+ ...
My solution is the same, but I hope a bit easier to understand Jul 9, 2003

And without writing any code.
But one thing: I have Excel 2002. I do not remember how it works in earlier versions.

Csaba Ban wrote:

For future reference, for anyone who might need to do the same thing:
http://www.cpearson.com/excel/SortByColor.htm

I still have to understand it though


Direct link Reply with quote
 
Robert Zawadzki  Identity Verified
Local time: 04:24
English to Polish
+ ...
My first answer did not make to the forum, somehow. Jul 9, 2003

If you are still interested in a solution without programming, let me know.

rzawadzk wrote:

And without writing any code.
But one thing: I have Excel 2002. I do not remember how it works in earlier versions.

Csaba Ban wrote:

For future reference, for anyone who might need to do the same thing:
http://www.cpearson.com/excel/SortByColor.htm

I still have to understand it though


Direct link Reply with quote
 


To report site rules violations or get help, contact a site moderator:


You can also contact site staff by submitting a support request »

Sorting Excel sheet by cell colours

Advanced search






WordFinder
The words you want Anywhere, Anytime

WordFinder is the market's fastest and easiest way of finding the right word, term, translation or synonym in one or more dictionaries. In our assortment you can choose among more than 120 dictionaries in 15 languages from leading publishers.

More info »
PerfectIt consistency checker
Faster Checking, Greater Accuracy

PerfectIt helps deliver error-free documents. It improves consistency, ensures quality and helps to enforce style guides. It’s a powerful tool for pro users, and comes with the assurance of a 30-day money back guarantee.

More info »



All of ProZ.com
  • All of ProZ.com
  • Term search
  • Jobs