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
For example, if the value in cell
10, then I want the value in cell
H2 to be colored red. If the value in cell
20, then I want the value in cell
H2 to be colored yellow. And so on.
How can I achieve this?