Thanks for your reply Roger. Unfortunately, that's exactly how the settings
are too.

This is the only conditional formatting rule in the spreadsheet, too.

Best,

ChipTay

"Roger Govier" wrote:

Hi Chip

Works fine for me.
Mark the cells againConditional FormattingManage RulesEdit
and check the values again to ensure it has got
= in first box, 10 in second box, percent in 3rd box
= in 4th box, 1 in 5th box, percent in 6th box

No option for setting the final values, but is should show as when <1 for
the Red down arrow.
--
Regards
Roger Govier



"Chip Taylor" wrote in message
...
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