Conditional formatting based on magnitude of change from previous value

Is there a way I can highlight cells that are differ from their adjacent cells by more than 10%?

Sample case:
Month 01 02 03 04 05 06 07 08 09 10 11 12
Sales 100 112 100 130 140 160 175 200 170 170 140 135

Here, In April, July and August, there is a sharp increase (>10%), while in September and November, there is a steep decline (>10%). I would like to format the sharp increases as Green, while sharp declines as red.

Can I do it using conditional formatting?


PS: I know I can attain this by creating a separate row for Month/Month growth in above example. But this example is a simplified version of my data. Real data is a lot more complex, and I need to do the formatting without creating any additional columns/rows.

Yes, you can do it. First select the cells that this will apply to (I'll assume from your example that we mean from C2 to M2, as January won't have any data to compare with. Then click on Conditional Formatting | New Rule, and choose Use a Formula ... from the bottom of the list. Enter this formula:

=(C2-B2)/B2 > 0.1

then click on the Format button, choose the Fill tab and select Green. OK your way out - Excel will automatically adjust the cell references to suit your selected cells.

Repeat for the declining values, but the formula will be:

=(C2-B2)/B2 < -0.1

and choose Red for the colour.

Hope this helps.

Pete

EDIT: revised formulae with different numbers

Please do not upload a picture of your file...rather, upload a sample of your workbook, showing what data you are working with, a few samples of your expected outcome is (manually entered is ok) and how you arrived at that. (exclude sensitive info)

1st, go into CF and remove the "" from those 2 rules
2nd, change the 2nd rule to =(B3-B2)/B2 < 0.1 (it currently is =(B3-B2)/B2 > 0.1)

Happy to help, but Pete did all the work