Advanced Conditinal Formatting

I would like to format a list of numbers accordingly:

1. If the number is negative, use a dark red, red, light red, three color scale conditional formatting rule.

2. If the number is positive, use a light green, green, dark green three color scale conditional formatting rule.

The problem i has it that it only uses one or the other, not both. How would i get it to pick one over the other based on cell value?

PS. if you are going to ask for a sample workbook then just copy this into a new workbook

$191.00
$231.00
$231.00
$271.00
$271.00
-$124.50
-$98.29
-$48.29
-$8.29
-$8.29
$31.71
$5.09
$92.59
$192.59
$242.59
$282.59
$282.59
$322.59
$322.59
$410.09
$360.09
$410.09
$450.09
$450.09
$490.09
$490.09
$577.59
$677.59
$727.59
$767.59
$767.59

jhren, OP's profile suggests 2003, Im not sure 2003 has that option, and they might not be able to open that file.

@ Gaiden, you may not get too many offers of help with a comment like...

PS. if you are going to ask for a sample workbook then just copy this into a new workbook

1 of the reasons we ask for a sample workbook (apart from you helping us to help you), is so that we can see what excel version you are using, and tailor suggestions accordingly. I know your profile says 2003, but some members forget to update their profile

I think that I accomplished what you want. I used a three colour scheme and set 0 as white.