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?
You have to be in edit mode in that cell - either click in the formula bar, hit F2, or double-click the cell. Then select the desired text to color. You'll see a pop-up menu with formatting options. If you do not see the pop-up menu, with the text selected, navigate to the Home tab and format from there. You could also right-click the selected text.
There is no way to conditionally format specific text parts of a cell, if that's what you're looking for.
There is no way to conditionally format specific text parts of a cell, if that's what you're looking for.
Zack Barresse This is easy in Excel 2013 but I haven't found a way to do this in Excel online. Interestingly, if I upload an excel file that already has party formatted text in a cell, it shows properly in Excel online, but it cannot be changed or replicated. When selecting a part of the text after pressing F2, the text formatting options are grayed out.