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.
Thanks for your suggestion. I tried it but the text color remained black.
- You have to change Format Cell into Text first
Thank you! I had a sheet where the column I tried to do this with was formatted as number and it took me forever to figure out why I couldn't change the text color on just the first character. Then I found your post on this thread and got it to work!
This help!!
- THANK YOU huyen!!! I stumbled upon this thread and you cleared up an issue that has frustrated me for over a year! Changing the Cell Format to Text worked!
