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!![]()
Bookmarks