Conditional Formatting

Andy · Jul 30, 2008

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?

John C · Jul 30, 2008

How about this for the conditional formatting:
=IF(ABS(A2-A1)>0.9*A1,1,0)

David Biddulph · Jul 30, 2008

=OR(A2<A1*0.1,A2>A1*1.9)

Mike H · Jul 30, 2008

Maybe this CF

=ABS(A1-A2)>A1*0.1

Mike

David Biddulph · Jul 30, 2008

That will work, but you don't need the IF(...,1,0)

=ABS(A2-A1)>0.9*A1 will do.

David Biddulph · Jul 30, 2008

The OP asked for 90%, not 10%, but the structure is OK.

Conditional Format based on sub-string	3	Apr 4, 2009
Conditional formatting problem	5	Jan 21, 2009
copying conditional formats	2	Nov 12, 2009
can conditional formatting varry the area it highlights based on c	3	Dec 15, 2009
Continuous Invoice Nos.	3	Feb 2, 2015
Conditional Formatting	4	Oct 20, 2009
Excel Conditional Formatting	1	Jun 21, 2019
conditional formatting	3	Jun 22, 2008

Ask a Question