How do I change the font color on certain text within a cell

%3CLINGO-SUB%20id%3D%22lingo-sub-1350737%22%20slang%3D%22en-US%22%3EHow%20do%20I%20change%20the%20font%20color%20on%20certain%20text%20within%20a%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1350737%22%20slang%3D%22en-US%22%3E%3CP%3Efor%20example%20%3A%26nbsp%3B%3C%2FP%3E%3CTABLE%20width%3D%22320%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%22320%22%20height%3D%2240%22%3ESoftlips%20Lip%20Balm%20Watermelon%20%26amp%3B%20Vanilla%20Special%202pk%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3Eif%20I%20want%20to%20change%20the%20color%20of%20Watermelon%20%26amp%3B%20Vanilla%20only%2C%20what%20should%20i%20do%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1350737%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1350781%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20I%20change%20the%20font%20color%20on%20certain%20text%20within%20a%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1350781%22%20slang%3D%22en-US%22%3EYou%20have%20to%20be%20in%20edit%20mode%20in%20that%20cell%20-%20either%20click%20in%20the%20formula%20bar%2C%20hit%20F2%2C%20or%20double-click%20the%20cell.%20Then%20select%20the%20desired%20text%20to%20color.%20You'll%20see%20a%20pop-up%20menu%20with%20formatting%20options.%20If%20you%20do%20not%20see%20the%20pop-up%20menu%2C%20with%20the%20text%20selected%2C%20navigate%20to%20the%20Home%20tab%20and%20format%20from%20there.%20You%20could%20also%20right-click%20the%20selected%20text.%3CBR%20%2F%3E%3CBR%20%2F%3EThere%20is%20no%20way%20to%20conditionally%20format%20specific%20text%20parts%20of%20a%20cell%2C%20if%20that's%20what%20you're%20looking%20for.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1350818%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20I%20change%20the%20font%20color%20on%20certain%20text%20within%20a%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1350818%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F10842%22%20target%3D%22_blank%22%3E%40Zack%20Barresse%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1565667%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20I%20change%20the%20font%20color%20on%20certain%20text%20within%20a%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1565667%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%20for%20your%20suggestion.%26nbsp%3B%20I%20tried%20it%20but%20the%20text%20color%20remained%20black.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1565752%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20I%20change%20the%20font%20color%20on%20certain%20text%20within%20a%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1565752%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F643259%22%20target%3D%22_blank%22%3E%40kishabrown311%3C%2FA%3E%26nbsp%3B%20Actually%20you%20CAN%20selectively%20color%20individual%20text%20parts%20within%20a%20cell.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22mtarler_0-1596565723954.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F210268iCF71FB88D31AD31E%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22mtarler_0-1596565723954.png%22%20alt%3D%22mtarler_0-1596565723954.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20easiest%20way%20is%20to%20click%20on%20the%20cell%20then%20click%20F2%20to%20edit%20in%20the%20cell%20(it%20does%20NOT%20work%20if%20you%20edit%20in%20the%20formula%20bar).%26nbsp%3B%20Then%20highlight%20the%20text%20you%20want%20to%20change%20color%20and%20use%20the%20pop-up%20quick%20edit%20window%20(or%20right%20click%20on%20it%20to%20get%20it%20to%20show)%20and%20change%20the%20text%20color.%20Or%20you%20can%20use%20the%20Home-%26gt%3BEdit%20-%26gt%3Btext%20color.%3C%2FP%3E%3CP%3EAnother%20trick%20is%20to%20actually%20type%20it%20elsewhere%20(i.e.%20Word)%20the%20way%20you%20want%20and%20then%20paste%20it%20into%20excel%3C%2FP%3E%3CP%3EThe%20last%20way%20is%20using%20VBA%2C%20which%20I%20won't%20get%20into.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

for example : 

Softlips Lip Balm Watermelon & Vanilla Special 2pk

if I want to change the color of Watermelon & Vanilla only, what should i do?

4 Replies
Highlighted
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.
Highlighted
Highlighted

Thanks for your suggestion.  I tried it but the text color remained black.

Highlighted

@kishabrown311  Actually you CAN selectively color individual text parts within a cell.

mtarler_0-1596565723954.png

 

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.