Use different fonts in one Excel cell?

Question

Is there a way to change the color and / or font of certain text in an excel cell? That is, I would like one part of the displayed value of the cell to be red, and the other part of the displayed value of the same cell to be blue (as an example). Since the displayed values ​​are calculated as formulas, I need some formatting formula that applies only the material inside the formula. I can't seem to find anything in the text.

Answer 1

If you want to do this based on a formula, you will need to write VBA. See this example.

Answer 2

. .

Answer 3

Take a look at Conditionally Formatting in excel.