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?
2
-
I might try to start superuser.com/questions/656864/excel-dual-graded-color-scales/… - you're going to have to write it– RaystafarianAug 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.– bvaughnAug 24, 2016 at 16:02
Add a comment
|
2 Answers
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.
answered Sep 26, 2021 at 5:16
If you have a constant number of entries, you could use top 10, 5 , 1 function and define font colours by category
