color values in a column based on percent difference +/-

[jrjarcher]

I have a table with 1 column that is the "delta" column. It contains a value that is the result of subtracting a value from column-A from column-B. I'd like to color the "delta" column as follows: if the delta value is >-10% color = Red; -5 to -10% color = orange, 0 to -4% color = yellow; +0 to +5% color = clear, i.e. no color; >+5% color = green.

I see I can set a min, mid, max percentage, but I'd like to specify these ranges & colors, if possible.

[to4kawa]

why substracting result is percentage?

[jrjarcher]

Are you referring to the '-' character in the percentage ranges? That's meant to be a negative percentage. So, if a delta is 10% less when compared to a baseline value, we want to see that value's color as red.

[jrjarcher]

Thought of a way to solve this. I created another column that is percentages. I can then use the "range" and set colors for all the different percentages that I want!!