Group Coloured Rows

[TONYC]

Is there any way in which coloured rows of data can be sorted / groupe
dependent upon their row colour?

Regards
Ton

 

[JE McGimpsey]

See

http://cpearson.com/excel/SortByColor.htm

 

[TONYC]

Thank you for the link, however I was hoping for something mor
simplistic, which doesn't appear possible.

Ton

 

[Jason Morin]

This may be somewhat simpler:

1. Press Ctrl+F3.
2. In the "Refer to" box, put:
=GET.CELL(63,!$A1)
and give it the name "color" (no quotes). Press OK.
3. In an open column in row 1, insert:
=color
and fill down.
4. Now sort your data by this column.

This assumes that column A is colored. Also, there are
issues using old XLM functions/macros in versions earlier
than XL2002.

http://tinyurl.com/3ujlb

HTH
Jason
Atlanta, GA

 

[Earl Kiosterud]

Tony,

Take a look at www.smokeylake.com/excel/excel_truths.htm. Read "Color as
data."