Forum Home
Press F1
 
Thread ID: 88503 2008-03-30 01:19:00 Unusual XL Sort. B.M. (505) Press F1
Post ID Timestamp Content User
654084 2008-03-30 01:19:00 Ok guys, here’s a curly one. :)

You have a number of cells in a column that are filled by a variety of numbers, most of which are derived differently.

You got through them manually and mark the cells you chose by changing the “fill” colour.

Having done that, is there any way to sort on colour?

Say, those with a Red fill first, followed by those with a Yellow fill, followed by those with a Green fill, followed by those with No fill.
B.M. (505)
654085 2008-03-30 01:29:00 See if this helps:

www.ozgrid.com
www.cpearson.com
beeswax34 (63)
1