Highlighting cell on value difference.

  • Thread starter Thread starter Neil
  • Start date Start date
N

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
 
Back
Top