Gradient Expression

[#1]

I am trying to create a gradient expression that will show the highest Amounts in Blue and the lowest in Green, descending down the colors as shown in my attached document.  However, I am stuck trying to come up with an expression to dynamically adjust the high and low parameters so the gradient uses the correct number of "stops" if you will.  My attached example uses randomly generated numbers, but my actual data contains both negative and positive numbers and can span quite a range, so the expression will need to account for that.

Thanks for the help!

[Anonymous · Accepted solution]

Rebecca

Have you looked at the Colormix() functions ?

Best Regards,     Bill

[#3]

So much easier! Thanks Bill!