Text Highlight
Thank you for your reply. If it is possible using "ActiveCell" method, how
to determine the "Start" position in the string. It could have multiple
"Start" positions in a string depending how many times that keyword appears
in the content. Thanks.
"Tim Williams" <saxifrax at pacbell dot net wrote in message
...
You could use .Find to locate all matching cells and then alter the
markup.
You definitely *can* modify only part of a cell's content formatting:
With ActiveCell.Characters(Start:=7, Length:=6).Font
.FontStyle = "Bold"
.Color = vbRed
End With
--
Tim Williams
Palo Alto, CA
"Paul Mak" wrote in message
...
I have an Excel file with over 25,000 row of records in 12 columns. I
need
to find and highlight the matching keywords in 3 of the columns. The
keywords is listed in a seperate workbook in the same Excel file. How do
I
loop throught all the keywords and highlight the matching one on the
other
workbook? I want only the matching keyword highlight but not the entire
cell. The same keyword could occour in more than one instance in the
content
of a cell. Thanks a million.
|