Forum Discussion
How do I change the font color on certain text within a cell
for example : Softlips Lip Balm Watermelon & Vanilla Special 2pk if I want to change the color of Watermelon & Vanilla only, what should i do?
kishabrown311 Actually you CAN selectively color individual text parts within a cell.
The easiest way is to click on the cell then click F2 to edit in the cell (it does NOT work if you edit in the formula bar). Then highlight the text you want to change color and use the pop-up quick edit window (or right click on it to get it to show) and change the text color. Or you can use the Home->Edit ->text color.
Another trick is to actually type it elsewhere (i.e. Word) the way you want and then paste it into excel
The last way is using VBA, which I won't get into.