| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
formatting a specific character or number in each cell within a rangeof cells
I am sending this to several Excel newsgroups, because I am not sure
which one if the most appropriate. I apologize in advance for the multiple postings. I have MS Excel 2000 (version 9.0.3821 SR-1). How can I format only a selected character or number within each cell in a specific range of cells? For instance if I have a cell containing “1234234”, how can I format it so that only the 2’s are bold or are colored? Obviously, I have a range of cells, and I want to format all the 2’s occurring in any of the cells as either bold or colored. Conditional formatting does not seem to allow me to do this, and I have been unable to find a formula that will accomplish this. Can someone help? Thank you. Colleen |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 - Formatting text in cell (character by character) | Excel Discussion (Misc queries) | |||
| formatting colour in cells when one cell contains a character | Excel Worksheet Functions | |||
| Add number from a cell that contains a specific character | Excel Worksheet Functions | |||
| Counting the number of times a specific character appears in a cell | Excel Worksheet Functions | |||
| how to format only a specific character or number in each cell withina range of cells | Excel Worksheet Functions | |||
![Colleen[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
