How do I sort a document that has cells colored? For example I want to
group (sort) all cells that have the background as red, blue ,green,
etc? Please no macro or programming codes. I am a basic
user...thank you


--
blueglass74
------------------------------------------------------------------------
blueglass74's Profile: http://www.excelforum.com/member.php...o&userid=10812
View this thread: http://www.excelforum.com/showthread...hreadid=515542

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

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"blueglass74"
wrote in message
...

How do I sort a document that has cells colored? For example I want to
group (sort) all cells that have the background as red, blue ,green,
etc? Please no macro or programming codes. I am a basic
user...thank you


--
blueglass74
------------------------------------------------------------------------
blueglass74's Profile:
http://www.excelforum.com/member.php...o&userid=10812
View this thread: http://www.excelforum.com/showthread...hreadid=515542

or see...
http://www.officeletter.com/blink/specialsort.html
for a review of a commercial sorting application by yours truly.
Jim Cone
San Francisco, USA


"blueglass74" wrote in message...
How do I sort a document that has cells colored? For example I want to
group (sort) all cells that have the background as red, blue ,green,
etc? Please no macro or programming codes. I am a basic
user...thank you
blueglass74

Unless you have some logic based on cell contents that determines colouring,
which could then be used in a helper column, you will be unable to do this
without macros or a commercial app such as the one that Jim has given you.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------


"Jim Cone" wrote in message
...

or see...
http://www.officeletter.com/blink/specialsort.html
for a review of a commercial sorting application by yours truly.
Jim Cone
San Francisco, USA


"blueglass74" wrote in message...
How do I sort a document that has cells colored? For example I want to
group (sort) all cells that have the background as red, blue ,green,
etc? Please no macro or programming codes. I am a basic
user...thank you
blueglass74

Since the rules are no macros or programming codes,
one way is to enter a value in an adjacent cell for
each color. When you sort, use that column as
the mechanism.