Hi everyone!
I'm trying to set this up:
I'm struggling to find the right settings in Conditional formatting to achieve it. Don't know if I should be using number, percent, percentile, etc, or what to set the values to. How should I set this up?
Thank you so much!
I'm trying to set this up:
- -10,000% to -100% solid red
- -99% to -1% decreasing red gradient
- 0% white
- 1% to 99% increasing red gradient
- 100% to 10,000% solid red
I'm struggling to find the right settings in Conditional formatting to achieve it. Don't know if I should be using number, percent, percentile, etc, or what to set the values to. How should I set this up?
Thank you so much!