The solution is to load the same overlay twice, use one for your positive range and the other for the negative range. This provides complete control over the thresholds and colors for both the positive and negative values.

The Scripting/Python/basic_paint_surface menu item illustrates the method.