The new Icon Set should have a switch for color reversal (like Excel). Small values are not always bad (red) and big values are not always good (green).
An alternative would be also an "Icon Set 2 invers colors".
Additionally there should be a way to change each icon but I have no plans to implement that in the near future.
I second this enhancement request. However, maybe it can be solved easier:
Instead of switching the order of icon sets, why not just switching the signs. It should be possible to select:
"<=" instead of ">="
Then, the problem is solved. I assume this is easier to implement?!?
This has been implemented for a long time. The options are just not exposed in the UI.
The remaining part that needs implementation for this feature is to introduce advanced configuration solutions for the icon set entry in the conditional format dialog.
The code for the icon set entry in the dialog is in sc/source/ui/condformatdlg
The code for the icon set model part, including the reverse flag, the configuration that allows any image for an icon can be found in sc/inc/colorscale.hxx and sc/source/core/data/colorscale.cxx