Hi all,

I hope you can help me.

I need to set a colour formatting in Excel 2010 based on the following:

I have a target, for instance 80%. If the actual result is between +- 10% is green, otherwise is red.

In this example the range will be 80+-8 that means if the actual result falls between 72 and 88 is green, otherwise is red.

If the target would be 55% the green range would be between 49.5 and 60.5 (55+-5.5).
I hope it is clear
Any idea?
Thanks in advance for helping!