Hello, I am trying to select rows from a spreadsheet based on the text colour of one of the cells in that row. Alternatively if I could sort the rows based on this criteria then that would also solve my problem. I am using quite an old version of Excel (2002) hence I can't find any predefined functions to do this. Is it necessary to write a Visual Basic macro to do this?

Any suggestions much appreciated

thanks