I have a spreadsheet with two columns: column I
contains numeric values, and column H
contains strings. I want to apply a custom color scale to column H
, but the colors in the color scale should be based on the values in column I
.
For example, if the value in cell I2
is 10
, then I want the value in cell H2
to be colored red. If the value in cell I2
is 20
, then I want the value in cell H2
to be colored yellow. And so on.
How can I achieve this?