D
Dave
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...
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...