Sorting by color

[blueglass74]

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

 

[Bob Phillips]

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

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"blueglass74" <[email protected]>
wrote in message
news:[email protected]...

 

[Jim Cone]

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


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

 

[Ken Wright]

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
------------------------------­------------------------------­----------------

 

[Bill (Unique as my name)]

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.