Highlighting cell on value difference.

[Neil]

Hi

I currently have the text changing colour if the value is greater (green)
and (red) if the same or lower compared to the value in the previous cell.
But i would like to have the background cell change colour if the value is
10% +/- difference from the previous cell as well. This would be very useful
if any one could help.

Thanks

 

[Sheeloo]

Try something like
=ABS((A2-A1)/A1) > 0.10