Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 389
  • Last Modified:

Excel 2010 - Sorting by Colors - What is the Color Hierarchy?

Which colors come first in sorting hierarchy? second? third?  etc.
I'm trying to understand the logic if I have six colors to sort by.  I can only apparently choose the FIRST color or LAST.
0
brothertruffle880
Asked:
brothertruffle880
  • 2
2 Solutions
 
jppintoCommented:
I guess that the order is the color palette number that you can see here:

http://www.mvps.org/dmcritchie/excel/colors.htm

jppinto
0
 
redmondbCommented:
brothertruffle880,

As I understand, there is no hierarchy - you must provide it yourself.

With the Sort dialog displayed...
 (1) Add levels for as many colors as you want to sort.
 (2)  For each level, change "Sort On" from "Values" to one of the color options (e.g. "Cell Color") and, for "Order", select the required color.

(As long as the colors are specified in the sequence you want, then you should leave "On Top" alone.)

Regards,
Brian.
0
 
redmondbCommented:
brothertruffle880,

Thanks!

FWIW, be careful - from 2007 onwards the old Excel palette approach was completely overhauled.

Regards,
Brian.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now