In Calc for each entry there’s a somewhat complicated formula to give out a case id, upon which I currently base the conditional solid colors formatting upon. Currently the best case is shown in green and the 2nd best case in blue (the rest is default). For the best case, the related data is fixed. For the 2nd best case, the related data has a range and if possible I’d like it to be reflected; ie from blue in the lowest part of that bracket to teal for it’s highest part.
To recap: there’s currently 2 solid colors, and I’d like it to become 1 solid + 1 color scale.
Thank you kindly