title: Is there a way in VBA to specify the scaling of conditional formatting such that negative numbers are coded in red?
body: <p>Wordy question but I am doing some interval based conditional formatting to work around hardcoded conditional formatting since former always take precedence over the latter. Essentially color codes between the hardcoded headers but in some instances, I only have one line between the hardcoded colors so a three scale conditional formatting will by default highlight a negative number in green; how can I force it in VBA to highlight negatives in red? </p>
  
  <pre><code>End With
  With Range(Replace(range_, "#", "N")).FormatConditions.AddColorScale(3)
  End With
  </code></pre>