Sorting by format (colour)

[CraigG]

Hello!

I have several rows of data. Some of the rows have the font changed to red. Is there a way of sorting the data so that all those with red text can be separated from those with 'normal'/black text?

Please tell me I don't have to go down them row by row to get them sorted! (Don't fancy having to do this on a Friday afternoon!)

Thanks.

Craig

 

[texasalynn]

take a look at Chip Pearson's info on sorting by color

http://www.cpearson.com/excel/colors.htm