HI,

i would like to learn how to apply colour scales in excel 2007 to my best advantage.

I have a pivot table with the rows as "Expenditure type" the columns are "Month"

I have the data showing one total for expenditure type for every month of the year. this works very well, but i would like to highlight using colours varioances over the months.

For example, januarys figure would be yellow as the benchmark for the year as it is the first figure. i would like feburary to go red if above jan, or green if the same or a lower figure. march would do the same, but checking against the feburarys figure. I feel that this should be possible, but i have only just got office 2007 and havent been able to fathom it out as yet!!

many thanks