0

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?

Improve this question
2
  • 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. Commented Aug 24, 2016 at 16:02

2 Answers 2

Reset to default
0

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.

Improve this answer
-1

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

Improve this answer

You must log in to answer this question.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.