Conditional formatting large range of cells, based on percentage of previous cell in range

Sorry, that's the best I could come up with for a subject and keep it as short as possible. Let me explain my issue more in depth.

I have a range of cells (C2:AG208), representing daily meter volumes. Columns C:AG represent 31 days, and rows 2:208 represent the individual meters. What I'm trying to do is use conditional formatting to highlight a cell in red if the value in the cell is 2% or more higher, or 2% or more lower, than the value in the previous cell.

I suppose I could do this on a cell-by-cell basis, but that's really a lot of cells to do that way.

Anyway, if there's a way to do this, I would appreciate the help.

Thanks.

Highlight the cells D2:AG208, click on Conditional Format, then New Rule and choose the option "Use a formula ..." from the bottom of the list. Then enter this formula in the dialogue box:

=AND(C2<>"",D2<>"",ABS((D2-C2)/C2)>0.02)

Then click on the Format button, then the Fill tab and choose the colour that you would like (red), then OK your way out. Excel will automatically adjust the cell references for the highlighted cells.

Hope this helps.

Pete

Thank you very much!