04-30-2020 10:30 AM
for example :
Softlips Lip Balm Watermelon & Vanilla Special 2pk |
if I want to change the color of Watermelon & Vanilla only, what should i do?
04-30-2020 10:41 AM
04-30-2020 10:53 AM
thanks
08-04-2020 10:59 AM
Thanks for your suggestion. I tried it but the text color remained black.
08-04-2020 11:31 AM
@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.