| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Search for text, change font color
I would like to have Excel search through a workbook, and change the font
color of a string of text wherever it occurs in the workbook. For example if I'm searching for "widgets", if cell A14 contains " no widgets were sold this week", I would like the font color of "widgets" to be red. If that can't be done, I'll settle for the font color of all of cell A14 to be red. Can it be done without VBA? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I change Font color specific text | Excel Discussion (Misc queries) | |||
| change font color on search | Excel Worksheet Functions | |||
| can you search by the color of the font? | Excel Discussion (Misc queries) | |||
| Excel should allow me to change text color & font within tabs. | Excel Discussion (Misc queries) | |||
| How can I automatically change the font color of text in cells th. | Excel Discussion (Misc queries) | |||
![John[_108_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
