I am sorry I wasn't clear enough. Let me put it in an example:
I have a spreadsheet full of information. Cell types vary from text, dates,
dollar amounts and general numbers. Based on external criteria, some cells
have been manually colored.
What I need is to be able to pull all the cells that are of a particular
color to a different section of the spreadsheet.
I hope this helps clarify the question.
Thank you for your responses.