Hi,

I have one chart with 2011's monthly sales figures, claims, complaints etc. and one chart with 2012's monthly sales figures, claims, complaints etc. What I want to do is compare these figures and if the 2012 figures are higher than 2011, they turn green, if lower turn red. If I use conditional formatting I can't drag that "formatting" to all of the other cells, right and down, I have to enter that format manually to each one. So what can I do so that I don't have to do that?

Thank you!