Is there a way to sort after conditional formatting. So, if I've set up a
conditional format to color my text red if the number is between 0 and 95,
then I want to sort so all red numbers are at the top of the spreadsheet?
Any ideas?

Thanks for your time and assistance.
Roberta

On Thu, 25 Oct 2007 05:08:00 -0700, rrupp
<(E-Mail Removed)> wrote:

You can't sort by color, but you can add a column to your query like
this:
SortColumn: Iif(SomeValue >= 0 and SomeValue <= 95, 1, 2)
Then sort by this column.

-Tom.


>Is there a way to sort after conditional formatting. So, if I've set up a
>conditional format to color my text red if the number is between 0 and 95,
>then I want to sort so all red numbers are at the top of the spreadsheet?
>Any ideas?
>
>Thanks for your time and assistance.
>Roberta

Thank you!!

"Tom van Stiphout" wrote:

> On Thu, 25 Oct 2007 05:08:00 -0700, rrupp
> <(E-Mail Removed)> wrote:
>
> You can't sort by color, but you can add a column to your query like
> this:
> SortColumn: Iif(SomeValue >= 0 and SomeValue <= 95, 1, 2)
> Then sort by this column.
>
> -Tom.
>
>
> >Is there a way to sort after conditional formatting. So, if I've set up a
> >conditional format to color my text red if the number is between 0 and 95,
> >then I want to sort so all red numbers are at the top of the spreadsheet?
> >Any ideas?
> >
> >Thanks for your time and assistance.
> >Roberta
>