| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Question
Say if I want to do a search and replace: for example "Marriages -
Public License" and I want to replace the word "Marriages" with the same word only in red and bold, can I do it without the whole thing being red and bold? I tried to do it but the whole thing turns red and bold and I only want the one word changed. Any ideas on how I can do that? Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Question
Try this:
In the formula bar, use the mouse pointer to highlight the text. Right-click and select "Format Cells" from the popup menu. Select the font color and bold and click the [OK] button. Press [enter] Does that help? *********** Regards, Ron XL2002, WinXP " wrote: Say if I want to do a search and replace: for example "Marriages - Public License" and I want to replace the word "Marriages" with the same word only in red and bold, can I do it without the whole thing being red and bold? I tried to do it but the whole thing turns red and bold and I only want the one word changed. Any ideas on how I can do that? Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Question
There are multiple instances of this so it wouldn't help to go to each
one and do that. That is why I want to use the search and replace feature. Ron Coderre wrote: Try this: In the formula bar, use the mouse pointer to highlight the text. Right-click and select "Format Cells" from the popup menu. Select the font color and bold and click the [OK] button. Press [enter] Does that help? *********** Regards, Ron XL2002, WinXP " wrote: Say if I want to do a search and replace: for example "Marriages - Public License" and I want to replace the word "Marriages" with the same word only in red and bold, can I do it without the whole thing being red and bold? I tried to do it but the whole thing turns red and bold and I only want the one word changed. Any ideas on how I can do that? Thanks |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Question
I understand.
I don't believe you can do what you're asking without using a VBA procedure. *********** Regards, Ron XL2002, WinXP " wrote: There are multiple instances of this so it wouldn't help to go to each one and do that. That is why I want to use the search and replace feature. Ron Coderre wrote: Try this: In the formula bar, use the mouse pointer to highlight the text. Right-click and select "Format Cells" from the popup menu. Select the font color and bold and click the [OK] button. Press [enter] Does that help? *********** Regards, Ron XL2002, WinXP " wrote: Say if I want to do a search and replace: for example "Marriages - Public License" and I want to replace the word "Marriages" with the same word only in red and bold, can I do it without the whole thing being red and bold? I tried to do it but the whole thing turns red and bold and I only want the one word changed. Any ideas on how I can do that? Thanks |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Question
I think you want something like this:
Sub Test() Dim objCell As Range strAux = "Marriages" For Each objCell In Selection If InStr(1, objCell.Value, strAux) 0 Then With objCell.Characters(InStr(1, objCell.Value, strAux), Len(strAux)).Font .FontStyle = "Bold" .ColorIndex = 3 End With End If Next End Sub escreveu na mensagem ups.com... There are multiple instances of this so it wouldn't help to go to each one and do that. That is why I want to use the search and replace feature. Ron Coderre wrote: Try this: In the formula bar, use the mouse pointer to highlight the text. Right-click and select "Format Cells" from the popup menu. Select the font color and bold and click the [OK] button. Press [enter] Does that help? *********** Regards, Ron XL2002, WinXP " wrote: Say if I want to do a search and replace: for example "Marriages - Public License" and I want to replace the word "Marriages" with the same word only in red and bold, can I do it without the whole thing being red and bold? I tried to do it but the whole thing turns red and bold and I only want the one word changed. Any ideas on how I can do that? Thanks |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Question
I tried it but it highlights the part "With objCell.Characters(InStr(1,
objCell.Value, strAux), " and it shows it in red and it also shows the part "Len(strAux)).Font" in red and then I get an error message that says "compile error: Syntax error" Rodrigo Ferreira wrote: I think you want something like this: Sub Test() Dim objCell As Range strAux = "Marriages" For Each objCell In Selection If InStr(1, objCell.Value, strAux) 0 Then With objCell.Characters(InStr(1, objCell.Value, strAux), Len(strAux)).Font .FontStyle = "Bold" .ColorIndex = 3 End With End If Next End Sub escreveu na mensagem ups.com... There are multiple instances of this so it wouldn't help to go to each one and do that. That is why I want to use the search and replace feature. Ron Coderre wrote: Try this: In the formula bar, use the mouse pointer to highlight the text. Right-click and select "Format Cells" from the popup menu. Select the font color and bold and click the [OK] button. Press [enter] Does that help? *********** Regards, Ron XL2002, WinXP " wrote: Say if I want to do a search and replace: for example "Marriages - Public License" and I want to replace the word "Marriages" with the same word only in red and bold, can I do it without the whole thing being red and bold? I tried to do it but the whole thing turns red and bold and I only want the one word changed. Any ideas on how I can do that? Thanks |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Question
"With objCell.Characters(InStr(1, objCell.Value, strAux), Len(strAux)).Font"
is only one line escreveu na mensagem ups.com... I tried it but it highlights the part "With objCell.Characters(InStr(1, objCell.Value, strAux), " and it shows it in red and it also shows the part "Len(strAux)).Font" in red and then I get an error message that says "compile error: Syntax error" Rodrigo Ferreira wrote: I think you want something like this: Sub Test() Dim objCell As Range strAux = "Marriages" For Each objCell In Selection If InStr(1, objCell.Value, strAux) 0 Then With objCell.Characters(InStr(1, objCell.Value, strAux), Len(strAux)).Font .FontStyle = "Bold" .ColorIndex = 3 End With End If Next End Sub escreveu na mensagem ups.com... There are multiple instances of this so it wouldn't help to go to each one and do that. That is why I want to use the search and replace feature. Ron Coderre wrote: Try this: In the formula bar, use the mouse pointer to highlight the text. Right-click and select "Format Cells" from the popup menu. Select the font color and bold and click the [OK] button. Press [enter] Does that help? *********** Regards, Ron XL2002, WinXP " wrote: Say if I want to do a search and replace: for example "Marriages - Public License" and I want to replace the word "Marriages" with the same word only in red and bold, can I do it without the whole thing being red and bold? I tried to do it but the whole thing turns red and bold and I only want the one word changed. Any ideas on how I can do that? Thanks |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Question
Got it. Thanks so much!!!!!!
Rodrigo Ferreira wrote: "With objCell.Characters(InStr(1, objCell.Value, strAux), Len(strAux)).Font" is only one line escreveu na mensagem ups.com... I tried it but it highlights the part "With objCell.Characters(InStr(1, objCell.Value, strAux), " and it shows it in red and it also shows the part "Len(strAux)).Font" in red and then I get an error message that says "compile error: Syntax error" Rodrigo Ferreira wrote: I think you want something like this: Sub Test() Dim objCell As Range strAux = "Marriages" For Each objCell In Selection If InStr(1, objCell.Value, strAux) 0 Then With objCell.Characters(InStr(1, objCell.Value, strAux), Len(strAux)).Font .FontStyle = "Bold" .ColorIndex = 3 End With End If Next End Sub escreveu na mensagem ups.com... There are multiple instances of this so it wouldn't help to go to each one and do that. That is why I want to use the search and replace feature. Ron Coderre wrote: Try this: In the formula bar, use the mouse pointer to highlight the text. Right-click and select "Format Cells" from the popup menu. Select the font color and bold and click the [OK] button. Press [enter] Does that help? *********** Regards, Ron XL2002, WinXP " wrote: Say if I want to do a search and replace: for example "Marriages - Public License" and I want to replace the word "Marriages" with the same word only in red and bold, can I do it without the whole thing being red and bold? I tried to do it but the whole thing turns red and bold and I only want the one word changed. Any ideas on how I can do that? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Possibly a loaded question, but I think | Excel Discussion (Misc queries) | |||
| How do I find and replace a question mark in Excel? | Excel Discussion (Misc queries) | |||
| Newbie With A Question | Excel Worksheet Functions | |||
| Anybody Help with previous question | Excel Discussion (Misc queries) | |||
| Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
Linear Mode
