conditional formatting sort

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

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.
 
Thank you!!

Tom van Stiphout said:
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.
Click to expand...
 
Back
Top