0

With Excel Conditional Formatting it's pretty easy to apply gradient fill to one column. But what I need is an entire table formatted with gradient fill based on values from a certain column.

There already is a question like this but about conditional formatting with only a few colors. So answers from that topic do not fit my case or seem incomplete and unclear to me.

Gluck
  • 39
  • 1
  • 2
  • 10
  • Choose the lowest and highest values from that certain column when you setup the conditional formatting rule – Foxfire And Burns And Burns Jul 28 '20 at 13:01
  • @FoxfireAndBurnsAndBurns the point is that I do not want Excel to format (set color from a gradient palette) for every cell separately. I want the same color for all cells in row depending on values in certain column. Looks like it's hard for me to explain it properly. Please check the link above; there is an illustration that can clarify my question. – Gluck Jul 28 '20 at 13:35
  • You should post a data example, and the expected output – Foxfire And Burns And Burns Jul 29 '20 at 06:48
  • 1
    Does this answer your question? [Conditional Formatting - Color Scale entire row based on one column](https://stackoverflow.com/questions/30731495/conditional-formatting-color-scale-entire-row-based-on-one-column) – gevra Feb 11 '21 at 11:01

0 Answers0