Extract data by line color?

Excel 2003, I have about 1000 lines and some of the lines are in different colors. Is it possible to extract 12 columns of data by line color? I looked for possible common link between the data so that I could sort and then copy. There is no common link for all other than all these phones a private. There is no column that denotes private, I just know that is what the common thread is and management needs a count. They are recognized on my spreadsheet by the color yellow. I am going to do this manually one by one but was wondering if there was a way to extract the data by VBA or formula?

Thanks
Ken