I'd like to build a macro that I can put in a button that would do this:
for only selected characters in a cell (i.e. partial cell content is selected), apply formatting: color, bold, etc.
The idea is to build a "quick format" custom toolbar, with which a user (myself in this case) could select a word or a phrase in a cell, and then click on a button in the custome toolbar (hovering near the point of action) and have the word or phrase turn red or bold (or both, or green, etc.) I want to reduce the mouse movements: go up to the formatting tool bar, click on color menu carefully, select color carefully. Instead, just select the text and click on the formatting treatment I want.
I don't see how to identify which characters in a cell are the selected characters. The rest I can figure out from recorded macros. (I wouldn't complain about a complete solution :-0)
Any help with this would be appreciated.