Sort by conditional formats?

[Guest]

I haven't seen anyone come close to this question, but is there a way to get
a sheet to sort by conditional formats I've set up. For instance, I've used
Green, Yellow, and Red. Is there an easy way to get it to sort it just by
the color, and not by the numbers contained in the cells?

 

[Bob Phillips]

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

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Guest]

can you sort by the condition that sets the format instead?

 

[Ron Rosenfeld]

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

Bob,

I don't believe that your colorindex UDF will show the color when it has been
set by conditional formatting. At least it didn't in my brief testing.

I think the OP will need to use a helper column (or UDF) that sorts based on
the conditional format formula.


--ron

 

[Bob Phillips]

Ron,

The UDF just gets the CI, so would also need a helper column to sort on. I
thought the article said that, but I will check it.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Ron Rosenfeld]

Ron,

The UDF just gets the CI, so would also need a helper column to sort on. I
thought the article said that, but I will check it.

--

You misunderstood me. My point was that your UDF would NOT get the CI when the
CI was set by CF. At least it did not on the limited testing I did.


--ron

 

[Bob Phillips]

Oh yes, it doesn't do that (yet!)> I have a page on that that I need to
integrate. Just need the time <g>

Bob