Hello,

I'm trying to do some conditional formatting on a pivot table.
Category            2006          2007
aerials                 100           200
batteries              100          200
bluetooth              100         200
data suites           200         150

I'd just like to compare at a basic level 2006 to 2007. If It's higher
than 2006, green, if not then red.
Ideally would like 3 states - if 30% or more over 2006 then green,
0-30% normal / yellow, if less than 2006 then red.

Although I seem to be able to do conditional formatting for 2007 v.
2006 one line at a time (just aerials for example), I have absolutely
no idea how to do the entire column.

It would be fantastic if it just compared the profit value, so that
anything could be put down the left column (just top 10 categories,
branches / areas etc).

In summary, how can i do conditional formatting on the whole column,
comparing 2006 profit to 2007?

Thanks

jamie