I have data in two text colors from one source that will be sorted by Excel
into specific places on several different forms.
Each color needs to go to a different set of forms. Can I use colored text
in an Excel formula to recognize the colored text in the source input, and
thereby send the data to the correct set of forms??

Ricky

If color is not created via Conditional Formatting see Chip Pearson's site for
working with colored cells and text using User Defined Functions.

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


Gord Dibben Excel MVP

On Fri, 11 Feb 2005 11:31:04 -0800, "Ricky"
wrote:

I have data in two text colors from one source that will be sorted by Excel
into specific places on several different forms.
Each color needs to go to a different set of forms. Can I use colored text
in an Excel formula to recognize the colored text in the source input, and
thereby send the data to the correct set of forms??