colored text in Excel formulas
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?? |
All times are GMT +1. The time now is 12:48 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com