software

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 triedquot;find and replace by formatquot;. it seems does not work on different
color format within a cell.

Then I use quot;text to columquot; 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.
www.cpearson.com/excel/colors.htm

=personal.xls!cellcolorindex(A1,1)
the 1 indicates Font and a value returned of 1 indicates Black Fontif you are unsure of colorindex numbers you can see them on my site
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 www.contextures.com/tiptech.html
or in a video format look for filtering in
at www.datapigtechnologies.com/ExcelMain.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
Search Page: www.mvps.org/dmcritchie/excel/search.htm

quot;yang xinquot; lt;yang gt; wrote in message ...
gt; I got a more than 2000 rows list. in one column there are names in deferent
gt; color. I need to remove names in black color.
gt;
gt; I triedquot;find and replace by formatquot;. it seems does not work on different
gt; color format within a cell.
gt;
gt; Then I use quot;text to columquot; to seperate the names to differet columns. to my
gt; suprise the names moveing to other columns changed color to black.
gt;
gt; I might not explain my question clearly. Please let me know how I could send
gt; the sreenshot for you better understanding my problem.
gt;
gt; Thank you in advance!