Excel conditional formatting gradient text color

Question

I am familiar with the conditional formatting in excel where you can fill the background of a range of cells with gradient colors according to their value. You can either choose a 2-color scale or a 3-color scale. However, this only seems possible for background colors of the cells but not the text/foreground color. Is this something I can do at all in excel?

Answer 1

You can manually format individual letters in cells, however there is no automatic (macro, conditional formatting...) way in Excel for managing parts of the same cell differently.

Answer 2

If you have a constant number of entries, you could use top 10, 5 , 1 function and define font colours by category