Sorting Shaded Cells in Excel

[scan2k]

Hello,
I have a very large spreadsheet with over 12,000 rows. I have approx. 200 shaded cells in one column. Can anyone tell me how to sort this column based on the shaded cell. All shaded cells are shaded the same color (e.g. Yellow in this case) Any help would be appreciated.

Thanks!!!

 

[SkipVought]

scan2k,

No way with worksheet functions.

What is/was the criteria for the shading?

Is is explicit shading or Conditional Formatting?



Skip,

http://www.TheOfficeExperts.com

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[xlbo]

take these words and re-arrange to form a sentance

Back your rod own are making you for a

If at all possible, use the logic that determined the shading to produce some kind of value result in a cell - trust me, it'll be faaaaaaaaaaar easier in the long run

Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244