How to apply a custom color scale to a column in Google Sheets based on the values in another column?

Question

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?

Answer 1

i think the tabble is like this

you can do it by add conditional formatting in the format menu select column H and then add the conditional format

#apply to H1:H1000
#custom formula
=I1=10

and then add new formula

=I1=20

and so on so your table look like this

explanation : =I1=10 means, if column I is equal to 10, then turn the formatting to red, because we apply it to column H, so the cell that turn to red is column H, even the formula is referring to column I by custom formula