Hello,
I have a table with data in columns C and D. In Column E, I have the difference between columns C and D, and then F is the percentage difference. I would like to have a two color gradient to color the high percentages, but only if the difference in column F is greater than 1. This is what the table looks like.
<tbody>
</tbody>
So, I would like the gradient to go across the cells in the percentage difference column only if the difference is greater than 1.
Is there a way to do this?
I have a table with data in columns C and D. In Column E, I have the difference between columns C and D, and then F is the percentage difference. I would like to have a two color gradient to color the high percentages, but only if the difference in column F is greater than 1. This is what the table looks like.
12/31/2016 | 3/31/2017 | Difference | Percentage Difference |
174 | 173 | 1 | 0.5747% |
770 | 765 | 5 | 0.6494% |
684 | 679 | 5 | 0.7310% |
494 | 491 | 3 | 0.6073% |
240 | 240 | 0 | 0.0000% |
<tbody>
</tbody>
So, I would like the gradient to go across the cells in the percentage difference column only if the difference is greater than 1.
Is there a way to do this?