| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Search and change text color or style only
Is it possible to use an input box (or other means of entry) to find and
change the properties of just the inputted text only within any column selected? I have macros that change the cell color or all the text in the cell, but I want to just highlight or bold or re-color the word of the text I'm searching for. (i.e. If a cell contains "INSTALL FASTENERS WITH MPX 5-50 SEALANT PER BAC 4025 METHOD 3." I want to have the option to change the appearance of just "MPX 5-50" or just "BAC 4025". I'm using Excel 2003. I've used conditional formatting and been to Chip Pearson's site but can't find the answer. Any help is greatly appreciated. Tony |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change font color on search | Excel Worksheet Functions | |||
| Protected sheet question -- way to allow user to change text alignment and font style? | Excel Programming | |||
| How do I change sheet notation from R1C1 style to A1 style in XL 2 | Setting up and Configuration of Excel | |||
| Change of text or background color doesn't change on the screen. | Excel Discussion (Misc queries) | |||
| Search for text, change font color | Excel Programming | |||
![Tony S.[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
