I'm having a problem with conditional formatting in an Excel 2007 pivot table.

The spreadsheet has a calculated field column which is the % difference in
revenue from one month to the next. After I select the cells in that column
and make a new formatting rule for Icon Sets, the arrows/colors are not
lining up with the values in the Rule Description.

Here are the rules:

Green (up arrow) when value is = 10 Percent
Yellow (sideways arrow) when <10 and = 1 Percent
Red (down arrow) when < 1

After I apply the rule, everything is green. From 250% through -150%, every
arrow is green and pointing up.

Thanks for your help.

ChipTay