software

I have a column of text data that has different colors for each row of text.
I need to be able to sort the data so that all the rows of the same color
will be displayed together. I am using OfficeXP.



quot;JimXLquot; wrote:

gt; I have a column of text data that has different colors for each row of text.
gt; I need to be able to sort the data so that all the rows of the same color
gt; will be displayed together. I am using OfficeXP.

Howmany different colors do you have? You can always insert a cloumn and
number the colored rows (1=yellow, 2=red and so forth). Then sort the rows
including the numbered column.

quot;JimXLquot; wrote:

gt; I have a column of text data that has different colors for each row of text.
gt; I need to be able to sort the data so that all the rows of the same color
gt; will be displayed together. I am using OfficeXP.

Hi Jim,

See Chip Pearson's Sorting by Color page at:

www.cpearson.com/excel/SortByColor.htm---
Regards,
Normanquot;JimXLquot; gt; wrote in message
...
gt;I have a column of text data that has different colors for each row of
gt;text.
gt; I need to be able to sort the data so that all the rows of the same color
gt; will be displayed together. I am using OfficeXP.
xldynamic.com/source/xld.Colo...r.html#sorting

--
Kind regards,

Niek Otten

quot;JimXLquot; gt; wrote in message
...
gt;I have a column of text data that has different colors for each row of
gt;text.
gt; I need to be able to sort the data so that all the rows of the same color
gt; will be displayed together. I am using OfficeXP.