I got a more than 2000 rows list. in one column there are names in deferent
color. I need to remove names in black color.

I tried"find and replace by format". it seems does not work on different
color format within a cell.

Then I use "text to colum" to seperate the names to differet columns. to my
suprise the names moveing to other columns changed color to black.

I might not explain my question clearly. Please let me know how I could send
the sreenshot for you better understanding my problem.

Thank you in advance!

Hi Yang,
You could check the color (font or the interior color) with user defined (UDF)
functions which you will find on Chip Pearson's site.
http://www.cpearson.com/excel/colors.htm

=personal.xls!cellcolorindex(A1,1)
the 1 indicates Font and a value returned of 1 indicates Black Font


if you are unsure of colorindex numbers you can see them on my site
http://www.mvps.org/dmcritchie/excel/colors.htm

you use another column as a helper column, and then filter out the
values that you don't want.

You can get help on filtering at http://www.contextures.com/tiptech.html
or in a video format look for filtering in
at http://www.datapigtechnologies.com/ExcelMain.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"yang xin" <yang wrote in message ...
I got a more than 2000 rows list. in one column there are names in deferent
color. I need to remove names in black color.

I tried"find and replace by format". it seems does not work on different
color format within a cell.

Then I use "text to colum" to seperate the names to differet columns. to my
suprise the names moveing to other columns changed color to black.

I might not explain my question clearly. Please let me know how I could send
the sreenshot for you better understanding my problem.

Thank you in advance!