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?

  • I might try to start superuser.com/questions/656864/excel-dual-graded-color-scales/… - you're going to have to write it Commented Aug 24, 2016 at 10:47
  • gradient formatting of the fore color is part of microsoft word. For the most part, not viable in excel as something that can be programmed. Exceptions is vba, or paste a html or word object that will have side effects.
    – bvaughn
    Commented Aug 24, 2016 at 16:02

2 Answers 2


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.


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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .