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?

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

--

HTH

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


"jbtenor1" wrote in message
...
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?

can you sort by the condition that sets the format instead?
--
paul
remove nospam for email addy!



"Bob Phillips" wrote:

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

--

HTH

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


"jbtenor1" wrote in message
...
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?

On Wed, 4 Jan 2006 22:29:25 -0000, "Bob Phillips"
wrote:

See http://www.xldynamic.com/source/xld....r.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

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" wrote in message
...
On Wed, 4 Jan 2006 22:29:25 -0000, "Bob Phillips"
wrote:

See http://www.xldynamic.com/source/xld....r.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

On Thu, 5 Jan 2006 17:06:06 -0000, "Bob Phillips"
wrote:

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

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


"Ron Rosenfeld" wrote in message
...
On Thu, 5 Jan 2006 17:06:06 -0000, "Bob Phillips"
wrote:

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