CF Question

[Spraggs]

Hello All,
I've got two cells...
A1 & B1.........

If cell B1 is =>120% of cell A1 then I want to format cell A1.
If cell B1 is =<80% of cell A1 then I want to format cell A1.
To prevent an error..
If cell A1 is =0 and cell B1 is >0 then format cell A1.

How would I do this? Hope this makes sense.
Thanks Jase

 

[VoG]

Try

=OR(B1>=A1*1.2,B1<=A1*0.8,AND(A1=0,B1>0))