Nice. I've had to so similar in the past. I created a sub in VBA that took the range to format and separator character (in your example as a colon) as parameters. After clearing the bold format for the cell, letting i be the first occurrence of the separator, it formatted characters 1 to i in bold (or whatever format you chose). Then I used the cell change event to call the sub with the required range and separator. I've also used images and text boxes and so on to display the results in similar fashion to yours. The vba is easy enough, but it is very bespoke, because people might want fonts that are bold, italic, large or whatever and there are always lots of caveats, such as not using the separator character in the rest of the text and so on. It usually works well though.
Hey Bill, a little disappointed but it is the way it is. BTW, it gets worse: even if you just use a cell format like “@:” (e.g. to add a “:” in headers of table columns) then in-cell format goes away (e.g. changing the color of a word) - the cell doesn’t even need to (partially) contain a formula (and column headers can’t be formulas in Excel tables anyway).
Great, thank you. And more valuable and inspiring is your attitude of not accepting “no, it cannot be done”
Nice. I've had to so similar in the past. I created a sub in VBA that took the range to format and separator character (in your example as a colon) as parameters. After clearing the bold format for the cell, letting i be the first occurrence of the separator, it formatted characters 1 to i in bold (or whatever format you chose). Then I used the cell change event to call the sub with the required range and separator.
I've also used images and text boxes and so on to display the results in similar fashion to yours.
The vba is easy enough, but it is very bespoke, because people might want fonts that are bold, italic, large or whatever and there are always lots of caveats, such as not using the separator character in the rest of the text and so on. It usually works well though.
Thanks Bill!
Great tip. Thank you !!
Great hack. I've run into the same problem, but unlike you, I failed to find a solution.
I did essentially this to help a guy in Australia with his PL report. I'll dig out a copy of the example (template) I sent him, if you're interested.
Hey Bill, a little disappointed but it is the way it is.
BTW, it gets worse: even if you just use a cell format like “@:” (e.g. to add a “:” in headers of table columns) then in-cell format goes away (e.g. changing the color of a word) - the cell doesn’t even need to (partially) contain a formula (and column headers can’t be formulas in Excel tables anyway).