Simple realy.

I've read an excel file with VB6, and due to certain criteria Have coloured Some Rows Red(3) Green(4) Blue(8) Yellow(6) scattered thru the spreadsheet, the remainder left default, this file is then saved.

Now the person I did this for wants to know if I can sort all the colors together.
He is not too bothered about sequence, but would like the greens ones first.

Is there anyway to do this? or is it easier to pass thru the file again , and using a blank column, set that to a value (for each colour) to allow me to sort on that?

Thanks in advance for your replies.