| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
how to format only a specific character or number in each cell withina range of 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 | |||
| Number format exactly the same, displays differently in some cells | Excel Discussion (Misc queries) | |||
| Number format for Combobox | Excel Discussion (Misc queries) | |||
| Count number of times a specific number is displayed in a cell ran | Excel Worksheet Functions | |||
| Custom number format always defaults last number to 0. | Excel Discussion (Misc queries) | |||
| How do i change numbers in text format to number format? | New Users to Excel | |||
Threaded Mode
