Highlighting cell on value difference.
 

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

Highlighting cell on value difference.
 

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

"Neil" wrote:

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