Thread
:
How to delete in batch the same color format letters in a cell
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
David McRitchie
Posts: n/a
How to delete in batch the same color format letters in a cell
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!
Reply With Quote