Sorting by color of font
 

I know how to sort data by number and alphabetic. But I have a color coded
document that I would like to sort by color. Can I do this without adding
another numeric column?

Sorting by color of font
 

Do you have Excel 2007 or an older version?
--
Gary''s Student - gsnu200845


"Benny Boy" wrote:

I know how to sort data by number and alphabetic. But I have a color coded
document that I would like to sort by color. Can I do this without adding
another numeric column?

Sorting by color of font
 

I have Excel 2002.

"Gary''s Student" wrote:

Do you have Excel 2007 or an older version?
--
Gary''s Student - gsnu200845


"Benny Boy" wrote:

I know how to sort data by number and alphabetic. But I have a color coded
document that I would like to sort by color. Can I do this without adding
another numeric column?

Sorting by color of font
 

In that case, see:

http://www.cpearson.com/excel/SortByColor.aspx
--
Gary''s Student - gsnu200845


"Benny Boy" wrote:

I have Excel 2002.

"Gary''s Student" wrote:

Do you have Excel 2007 or an older version?
--
Gary''s Student - gsnu200845


"Benny Boy" wrote:

I know how to sort data by number and alphabetic. But I have a color coded
document that I would like to sort by color. Can I do this without adding
another numeric column?

Sorting by color of font
 

"Benny Boy" wrote:

I have Excel 2002.

"Gary''s Student" wrote:

Do you have Excel 2007 or an older version?
--
Gary''s Student - gsnu200845


"Benny Boy" wrote:

I know how to sort data by number and alphabetic. But I have a color coded
document that I would like to sort by color. Can I do this without adding
another numeric column?