How to delete in batch the same color format letters in a cell

[Guest]

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!

 

[David McRitchie]

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