A
Andy
If A2 is within plus or minus 90% of cell A1 I do not wish to format it
conditionally, otherwise I wish to highlight it.
Formula is?
conditionally, otherwise I wish to highlight it.
Formula is?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
John C
How about this for the conditional formatting:
=IF(ABS(A2-A1)>0.9*A1,1,0)
=IF(ABS(A2-A1)>0.9*A1,1,0)
D
David Biddulph
=OR(A2<A1*0.1,A2>A1*1.9)
M
Mike H
Maybe this CF
=ABS(A1-A2)>A1*0.1
Mike
=ABS(A1-A2)>A1*0.1
Mike
D
David Biddulph
That will work, but you don't need the IF(...,1,0)
=ABS(A2-A1)>0.9*A1 will do.
=ABS(A2-A1)>0.9*A1 will do.
D
David Biddulph
The OP asked for 90%, not 10%, but the structure is OK.