Sort Table by ALL COLORS

[williekay]

I have a table in EXCEL 2010 that has conditional formating to color cells in 12 different columns with 16 different colors - is there a way to say :: SORT TABLE by ANY(or all) COLORED CELLS

Willie

 

[SkipVought]

hi,

I am confused! How can you sort by "ANY(or all)" of whatever?

Please explain exactly what you mean.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[jges]

Why not just sort your data using the same criteria as the conditional formatting?

 

[SkipVought]

My question is, how can you SORT by ANY, which means sort by one or more of something, aside from the CF issue???

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[MakeItSo]

Hi Willie,

I assume you want to sort in a fashion that All rows with coloured cells come first, no matter WHICH of their cells is coloured?
How about this:
a) AFAIK, there is no formula in Excel to check whether a cell is coloured. Glad if someone knows different though.
b) Therefore you'll need a little VBA for the next step:

- Put an "X" in the first cell in the first unused column, say AA1, if any of the cells in this row is coloured.
- After that, you can sort the sheet by by column AA, with column A as a second sort parameter (you'll surely want some kind of sorting based on the contents too, I'm sure).

Will that do?

Cheers,
MakeItSo

“Knowledge is power. Information is liberating. Education is the premise of progress, in every society, in every family.” (Kofi Annan)
Oppose SOPA, PIPA, ACTA; measures to curb freedom of information under whatever name whatsoever.

 

[Geates]

I agree with both jges and MakeItSo. I would go a step further and suggest you combine the two idea. When your CF routine runs to determine a cells color, write a value to an off-screen cell to symbolize sorting order.

-Geates

http://ns7.webmasters.com/caspdoc/html/vbscript_language_reference.htm

 

[SkipVought]

I believe that there are UNANSWERED questions.

The OP states that there is "conditional formating to color cells in 12 different columns".

Then the OP requires to "SORT TABLE by ANY(or all) COLORED CELLS"

So how would any of you sort a table by ANY(or all) colored cells in 12 different columns?

Does that make sense? Maybe I'm missing something!

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]