Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how to format only specific characters or numbers within each cellwithin a 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 2s are bold or are colored? Obviously, I have a range of cells, and I want to format all the 2s 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 | |||
Convert numbers from text format to number format | Excel Discussion (Misc queries) | |||
Using Replace to Format Negative Numbers | Excel Discussion (Misc queries) | |||
how do I highlite text within a cell (specific characters) | Excel Discussion (Misc queries) | |||
Numbers aren't changing with new format why? | Excel Discussion (Misc queries) | |||
Mail Merge - format of numbers | Excel Discussion (Misc queries) |