I need to add conditional formatting to my pivot table using a formula. I
need for a cell to become red, yellow or green if another cell is a certain
number. So for example if cell A5 is 1 through 5, I need cell B5 to be
green. I can't find any information that tells me how to do this. I am
using Excel 2003.

In addition, I need to find a way to shift cells down if the pivot table
gets larger when I refresh. I cannot find a way to do this either.

Thanks in advance.