I am trying to set up a two color conditional scale where the highest is green, the lowest is red, and where it flips from green at a reference cell. So for example.
| Target | Ex1 | Ex2 | Ex3 | Ex4 | Ex5 |
|---|---|---|---|---|---|
| .5 | .4 | .2 | .6 | .1 | .9 |
I would like Ex 1 to be light red, Ex 2 to be medium red, and Ex4 to be dark red. And I would like Ex3 to be light green and Ex5 to be dark green.
Three color formatting will not work as it will result in Ex1 and Ex3 being not red or green and I need all to be either red or green.
Is there a way to do this?
