conditional formatting sort

[rrupp]

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

 

[Tom van Stiphout]

On Thu, 25 Oct 2007 05:08:00 -0700, rrupp

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.

 

[rrupp]

Thank you!!

On Thu, 25 Oct 2007 05:08:00 -0700, rrupp

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.