Excel Spreadsheet - Highlighted Rows.

[China Doll]

Evening All,

I'm setting up a spreadsheet. Certain rows are coloured/highlighted to symbolise something. I would like the spreadsheet to automatically sort the coloured rows together, and if poss, actually put them on the next page. Does anyone else know if this can be done? I could have sworn I read somewhere that it could be but I'm having no luck at the moment.

Cheers,
China xx

[ll_billym]

Not easily, you need to know how to use the Visual Basic functions of Excel.

There is a tutorial here that explains how to do it but you do need some background knowledge.

http://www.bettersolutions.com/excel/EAK113/QO 520032321.htm

Apparently the ability to sort by colour will be in Excel 2007.