Add the ability to color characters in the cell display value where the cell has a formula
Add the ability to color characters in a cells displayed value where the cell has a formula.
Currently I can select a sub string of text within a cell and change the color or make the text bold. But there is no ability to be able to do this when the cell has a formula. For example, make the last 5 charaters of the result value os the cell Red and the rest would be the default color of the cell font.
i guees it's conditional formating for cell characters. I can do this through code and helprer cells and the onChange event, but it's clunky and would not be efficient for more than a few cells.