Sorting by Cell COLOR

[ycap]

After a conditional formating is applied to a column, how do I sort by cell color. Is there a formula that would identify the background or text color?

If there is and the formula could give me the color#, maybe I could just sort by that later. Any inputs??

 

[Scott Huish]

What are your Conditonal Formatting Conditions and the ranges involved?

 

[ycap]

Thanks for your reply.

On column A, I have dollar amounts. Conditional formating basically identifies ranges. All dollar amounts between 1-10,000 are Shown in Yellow, 10-20,000 are in Green, 20-50,000 are in Blue and over 50K in Red. The amounts of rows vary every day; but could easily be over 40,000 rows.

I would like to be able to sort by colors, or if I need to add a column to enter a formula that would identify the background color#, then sort by that, its fine as well.

Once agan, thanks for your help

 

[Scott Huish]

Use a new column, put this formula in it and copy down:

=MATCH($A1,{1,10000.01,20000.01,50000.01})

Sort on this column.