software

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 www.xldynamic.com/source/xld....r.html#sorting

--

HTH

RP
(remove nothere from the email address if mailing direct)quot;jbtenor1quot; gt; wrote in message
...
gt; I haven't seen anyone come close to this question, but is there a way to
get
gt; a sheet to sort by conditional formats I've set up. For instance, I've
used
gt; Green, Yellow, and Red. Is there an easy way to get it to sort it just by
gt; 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!
quot;Bob Phillipsquot; wrote:

gt; See www.xldynamic.com/source/xld....r.html#sorting
gt;
gt; --
gt;
gt; HTH
gt;
gt; RP
gt; (remove nothere from the email address if mailing direct)
gt;
gt;
gt; quot;jbtenor1quot; gt; wrote in message
gt; ...
gt; gt; I haven't seen anyone come close to this question, but is there a way to
gt; get
gt; gt; a sheet to sort by conditional formats I've set up. For instance, I've
gt; used
gt; gt; Green, Yellow, and Red. Is there an easy way to get it to sort it just by
gt; gt; the color, and not by the numbers contained in the cells?
gt;
gt;
gt;

On Wed, 4 Jan 2006 22:29:25 -0000, quot;Bob Phillipsquot;
gt; wrote:

gt;See 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)quot;Ron Rosenfeldquot; gt; wrote in message
...
gt; On Wed, 4 Jan 2006 22:29:25 -0000, quot;Bob Phillipsquot;
gt; gt; wrote:
gt;
gt; gt;See www.xldynamic.com/source/xld....r.html#sorting
gt;
gt; Bob,
gt;
gt; I don't believe that your colorindex UDF will show the color when it has
been
gt; set by conditional formatting. At least it didn't in my brief testing.
gt;
gt; I think the OP will need to use a helper column (or UDF) that sorts based
on
gt; the conditional format formula.
gt;
gt;
gt; --ron
On Thu, 5 Jan 2006 17:06:06 -0000, quot;Bob Phillipsquot;
gt; wrote:

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

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!)gt; I have a page on that that I need to
integrate. Just need the time lt;ggt;

Bobquot;Ron Rosenfeldquot; gt; wrote in message
...
gt; On Thu, 5 Jan 2006 17:06:06 -0000, quot;Bob Phillipsquot;
gt; gt; wrote:
gt;
gt; gt;Ron,
gt; gt;
gt; gt;The UDF just gets the CI, so would also need a helper column to sort on.
I
gt; gt;thought the article said that, but I will check it.
gt; gt;
gt; gt;--
gt;
gt; You misunderstood me. My point was that your UDF would NOT get the CI
when the
gt; CI was set by CF. At least it did not on the limited testing I did.
gt;
gt;
gt; --ron