N
NURTH
Hi,
I would appreciate some help with some conditional formatting in XL2007.
I have two colums of numbers
A is the target number
B is the real life number
If A is 50 and B is 55, then B is 5 points off target.
I would like to have a third colum showing
the off target figure
as a percentage of the target
irrespective of the fact that the figure could be above or below the target.
Like I don't care if the real life figure is more or less, if it's not on
target (within a 5% margin of error) it needs to be corrected.
Then I would like to set up the conditional formatting to show me
a green icon for on taget or 0- 5% off
orange for between 5% and 10% and
red for anything beyond 10%.
Thanks for any help.
Nurth
I would appreciate some help with some conditional formatting in XL2007.
I have two colums of numbers
A is the target number
B is the real life number
If A is 50 and B is 55, then B is 5 points off target.
I would like to have a third colum showing
the off target figure
as a percentage of the target
irrespective of the fact that the figure could be above or below the target.
Like I don't care if the real life figure is more or less, if it's not on
target (within a 5% margin of error) it needs to be corrected.
Then I would like to set up the conditional formatting to show me
a green icon for on taget or 0- 5% off
orange for between 5% and 10% and
red for anything beyond 10%.
Thanks for any help.
Nurth