Created attachment 115217 [details] Conditional Formatting with Gradient Presets mockup When setting color scale conditional formatting with 2 or 3 entries, it would be useful to have color gradient presets for users to choose from rather than having to select individual colors, similar to how we have presets for icon sets. Example 3 Entries Presets: Heat Gradient: Red, Orange 1, White Traffic Sign Gradient: Red, Yellow, Green Blue, White, Red (not sure the name for this one) http://www.ncl.ucar.edu/Applications/Images/h_long_5_lg.png Example 2 Entries Presets: http://home.online.no/~t-o-k/Colour_Gradients/ There is also a large gradient list at http://colrd.com/gradient/
Setting NEW as ux-advise enhancement.
R has a lot of cool graphic features including colorRamp() https://stat.ethz.ch/R-manual/R-devel/library/grDevices/html/colorRamp.html The code should be available somewhere.
Excel has also implemented a few 3 and 2 entry color scale presets, but this feature is only available in its toolbar drop down [attachment 109790 [details]]: Green, Yellow, Red Red, Yellow, Green Green, White, Red Red, White, Green Light Blue, White, Red Red, White, Light Blue White, Red Red, White Green, White White, Green Green, Yellow Yellow, Green