Conditional formatting based on another value

[keymoo]

I have two number columns A and B.

I want to highlight column A with either a GREEN fill or RED fill.

If the value of A is greater than B*0.95 AND A is less than B*1.1 fill it GREEN.
If the value of A is greater than or equal to B*1.1 OR A is less than or equal to B*0.95 fill it RED.

Been struggling to get this working, thanks for looking.

I'm using Office 365 latest version.

 

[Fluff]

Assuming your data starts in A2, select A2:a & last row and use this formula for green
=AND(A2>B2*0.95, A2<B2*1.1)
and this for red
=AND(A2<>"",OR(A2<=B2*0.95, A2>=B2*1.1))