software

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: www.excelforum.com/member.php...oamp;userid=10812
View this thread: www.excelforum.com/showthread...hreadid=515542See xldynamic.com/source/xld.Colo...r.html#sorting

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

quot;blueglass74quot; gt;
wrote in message
...
gt;
gt; How do I sort a document that has cells colored? For example I want to
gt; group (sort) all cells that have the background as red, blue ,green,
gt; etc? Please no macro or programming codes. I am a basic
gt; user...thank you
gt;
gt;
gt; --
gt; blueglass74
gt; ------------------------------------------------------------------------
gt; blueglass74's Profile:
www.excelforum.com/member.php...oamp;userid=10812
gt; View this thread: www.excelforum.com/showthread...hreadid=515542
gt;

or see...
www.officeletter.com/blink/specialsort.html
for a review of a commercial sorting application by yours truly.
Jim Cone
San Francisco, USAquot;blueglass74quot; 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
blueglass74Unless 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 :-)
------------------------------*------------------------------*----------------quot;Jim Conequot; gt; wrote in message
...
gt;
gt; or see...
gt; www.officeletter.com/blink/specialsort.html
gt; for a review of a commercial sorting application by yours truly.
gt; Jim Cone
gt; San Francisco, USA
gt;
gt;
gt; quot;blueglass74quot; wrote in message...
gt; How do I sort a document that has cells colored? For example I want to
gt; group (sort) all cells that have the background as red, blue ,green,
gt; etc? Please no macro or programming codes. I am a basic
gt; user...thank you
gt; blueglass74
gt;
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.