Conditional Formatting with Percent of a Value

[ub33]

Hello - I am trying to apply a Conditional Format to find if a value in 1 cell is within a Percent Tolerance
A1 B1
2453 4086

So I want to colour B1 (4086) Red if it is greater or less than 15% of A (2453)
So I want to colour B1 (4086) Yellow if it is greater or less than 10% of A (2453)
So I want to colour B1 (4086) Green is greater or less than 5% of A (2453)

For Clarity 2450 is Target Units to Produce and 4086 is actual Units Produced.

I hope this makes some sense as I have struggled to find it online anywhere

Thanks

Peter

[Vikas_Gautam]

There is problem with the conditions you have specified.
However here is the work around.

Select Column B fully.
Use following condition formatting formula ( Home-->Conditional formatting--> new rule--> use formula to determine...)

For Red
=B1>(A1*0.15)

For Yellow
=AND(B1>=(A1*0.10),B1<(A1*0.15))

For Green
=AND(B1>=(A1*0.05),B1<(A1*0.10))

Change Formulas appropriately to suit your conditions.

[samba_ravi]

For Red
=ABS(B1-A1)/A1>=.15

For Yellow
=AND(ABS(B1-A1)/A1>=0.1,ABS(B1-A1)/A1<0.15)

For Green
=AND(ABS(B1-A1)/A1>=0.5,ABS(B1-A1)/A1<0.10)
use the above formula in conditional format