Sorting by cell Color

I have a list of names in a spreadsheet and have color-coded certain ones.
Is there a way to sort by the color of the cell or row?

Thanks,
Ted

Ted,

One way - see my post here...
http://makeashorterlink.com/?F3C053B9B

Jim Cone
San Francisco, USA


<t2true.1to3ib_1123877104.724@excelforum-nospam.com>
wrote in message
news:t2true.1to3ib_1123877104.724@excelforum-nospam.com...
I have a list of names in a spreadsheet and have color-coded certain
ones. Is there a way to sort by the color of the cell or row?
Thanks,
Ted
t2true

See http://www.xldynamic.com/source/xld....r.html#sorting

--

HTH

RP
(remove nothere from the email address if mailing direct)


"t2true" <t2true.1to3ib_1123877104.724@excelforum-nospam.com> wrote in
message news:t2true.1to3ib_1123877104.724@excelforum-nospam.com...
>
> I have a list of names in a spreadsheet and have color-coded certain
> ones.
> Is there a way to sort by the color of the cell or row?
>
> Thanks,
> Ted
>
>
> --
> t2true
> ------------------------------------------------------------------------
> t2true's Profile:
http://www.excelforum.com/member.php...fo&userid=3877
> View this thread: http://www.excelforum.com/showthread...hreadid=395445
>

t2true,
and

http://www.cpearson.com/excel/colors.htm

Dave

Originally Posted by t2true

I have a list of names in a spreadsheet and have color-coded certain ones.
Is there a way to sort by the color of the cell or row?

Thanks,
Ted