Sorting by cell Color

[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

[Jim Cone]

Ted,

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

Jim Cone
San Francisco, USA


<[email protected]>
wrote in message
news:[email protected]...
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

[Bob Phillips]

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

--

HTH

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


"t2true" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[Piranha]

t2true,
and

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

Dave

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