Conditional Formatting

  • Thread starter Thread starter Andy
  • Start date Start date
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?
 
How about this for the conditional formatting:
=IF(ABS(A2-A1)>0.9*A1,1,0)
 
That will work, but you don't need the IF(...,1,0)

=ABS(A2-A1)>0.9*A1 will do.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formatting - find cells containg "+" 3
copying conditional formats 2
can conditional formatting varry the area it highlights based on c 3
Conditional Formatting 4
Conditional Format based on sub-string 3
Excel Highlighting duplicates 0
Conditional formatting problem 5
Excel Conditional Formatting 1

Back
Top