Sort by conditional formats?

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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
> > 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"
<[email protected]> 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" <[email protected]> wrote in message
news:[email protected]...
> On Wed, 4 Jan 2006 22:29:25 -0000, "Bob Phillips"
> <[email protected]> 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"
<[email protected]> 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" <[email protected]> wrote in message
news:[email protected]...
> On Thu, 5 Jan 2006 17:06:06 -0000, "Bob Phillips"
> <[email protected]> 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