Thread: Selecting rows based on text colour

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

If the cell is colored using Conditional Formatting, then use the same criteria as the Conditional Formatting.

For VBA solutions see here:

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

Look at the two functions:

ColorIndexOfOneCell and ColorIndexOfRange

Thank you very much for the tip