Oh, just in case you think I'm just being sarcastic, Excel 2007 allow you to
display Data Bars in cells which sound like what you want.
--
Thanks,
Shane Devenshire


"Dave" wrote:

How do I conditionally format cells within a column of a pivot table based on
their relationship with another value within the pivot table? For example, I
want to format 2007 enrollment based on whether its up, down or the same as
2006 enrollment. The pivot is set up with years as column data (2007, 2006,
2005). The first row has enrollments of 10 vs. 15 last year - I want that
cell to be red. The 2nd row has enrollments of 25 this year vs. 20 last
year, I want that cell to be green.

In a perfect world, I would like to display a bar showing how up or down
enrollments are compared to last year...