Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change color of specific text piece
Any idea of a suitable piece of code to convert the fonts' color of ONLY the
WORD "people", in the CURRENT SELECTION? In other words, instead of hitting F2 a hundred times, placing the cursor to the specific piece of text everytime, selecting it, and changing it to red (for example), and then again moving to the other cell, there should be a single code to carryout the exercise. -- Thanx in advance, Best Regards, Faraz |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change color of specific text piece
Hi Faraz
Try the below macro which works on the current selection Sub FindAndColorCharacterWithinCell() Dim cell As Range, intPos as Integer For Each cell In Selection With cell Do intPos = InStr(intPos + 1, .Value, "people", vbTextCompare) If intPos Then ..Characters(Start:=intPos, Length:=6).Font.FontStyle = "Bold" ..Characters(Start:=intPos, Length:=6).Font.ColorIndex = 3 End If Loop Until intPos = 0 End With Next End Sub -- Jacob "Faraz A. Qureshi" wrote: Any idea of a suitable piece of code to convert the fonts' color of ONLY the WORD "people", in the CURRENT SELECTION? In other words, instead of hitting F2 a hundred times, placing the cursor to the specific piece of text everytime, selecting it, and changing it to red (for example), and then again moving to the other cell, there should be a single code to carryout the exercise. -- Thanx in advance, Best Regards, Faraz |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change color of specific text piece
Here is a macro that should do what you want...
Sub PeopleColorer() Dim Cell As Range, StartAt As Long For Each Cell In Selection StartAt = InStr(1, Cell.Value, "people", vbTextCompare) Do While StartAt 0 Cell.Characters(StartAt, 6).Font.ColorIndex = 3 StartAt = InStr(StartAt + 1, Cell.Value, "people", vbTextCompare) Loop Next End Sub -- Rick (MVP - Excel) "Faraz A. Qureshi" wrote in message ... Any idea of a suitable piece of code to convert the fonts' color of ONLY the WORD "people", in the CURRENT SELECTION? In other words, instead of hitting F2 a hundred times, placing the cursor to the specific piece of text everytime, selecting it, and changing it to red (for example), and then again moving to the other cell, there should be a single code to carryout the exercise. -- Thanx in advance, Best Regards, Faraz |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change color of specific text piece
XClent
-- Thanx in advance, Best Regards, Faraz "Jacob Skaria" wrote: Hi Faraz Try the below macro which works on the current selection Sub FindAndColorCharacterWithinCell() Dim cell As Range, intPos as Integer For Each cell In Selection With cell Do intPos = InStr(intPos + 1, .Value, "people", vbTextCompare) If intPos Then .Characters(Start:=intPos, Length:=6).Font.FontStyle = "Bold" .Characters(Start:=intPos, Length:=6).Font.ColorIndex = 3 End If Loop Until intPos = 0 End With Next End Sub -- Jacob "Faraz A. Qureshi" wrote: Any idea of a suitable piece of code to convert the fonts' color of ONLY the WORD "people", in the CURRENT SELECTION? In other words, instead of hitting F2 a hundred times, placing the cursor to the specific piece of text everytime, selecting it, and changing it to red (for example), and then again moving to the other cell, there should be a single code to carryout the exercise. -- Thanx in advance, Best Regards, Faraz |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change color of specific text piece
Thanx bro!
-- Best Regards, Faraz "Rick Rothstein" wrote: Here is a macro that should do what you want... Sub PeopleColorer() Dim Cell As Range, StartAt As Long For Each Cell In Selection StartAt = InStr(1, Cell.Value, "people", vbTextCompare) Do While StartAt 0 Cell.Characters(StartAt, 6).Font.ColorIndex = 3 StartAt = InStr(StartAt + 1, Cell.Value, "people", vbTextCompare) Loop Next End Sub -- Rick (MVP - Excel) "Faraz A. Qureshi" wrote in message ... Any idea of a suitable piece of code to convert the fonts' color of ONLY the WORD "people", in the CURRENT SELECTION? In other words, instead of hitting F2 a hundred times, placing the cursor to the specific piece of text everytime, selecting it, and changing it to red (for example), and then again moving to the other cell, there should be a single code to carryout the exercise. -- Thanx in advance, Best Regards, Faraz . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I change Font color specific text | Excel Discussion (Misc queries) | |||
Change text color of specific date range by macro in Excel | Excel Programming | |||
Change color of specific text within a cell? | Excel Programming | |||
search a column for a specific piece of data using vba | Excel Programming | |||
search column for a specific piece of data using vba | Excel Programming |