Group Coloured Rows

  • Thread starter Thread starter TONYC
  • Start date Start date
T

TONYC

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

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

Ton
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

coloured roes static while sorting data 3
Insert blank row after change in cell value not working. 1
Conditional formatting in Excel 2010 2
Delete rows that contain colours? 4
conditional formatting to group rows with repeating entries 3
Colours in Print preview? 2
Coloured Cells 8
Sort / Print only Coloured rows of a table. 5

Back
Top