• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Help with conditional formatting formula

Im_Offset

Member
Hello to all you excellent excelers:

I am unable to figure out the correct formula for this conditional formatting need:

in column B from B2:B7 is a range of numbers that have been manually entered.
For example:
100
110
120
130
140
150

in column C from C2:C7 is another range of numbers that have been calculated by a formula.

What I want to do is conditionally highlight a number in column C if it is not equal to the number in the same row in column B by +/- 1.
So if B2 is 100 and C2 is 101 then it would not be highlighted
But if B3 is 110 and C3 is 115, then it would be highlighted because it is not between B3 +/-1 (i.e. 109 to 111).

What formula would I write in the conditional formatting tool in order to get the cells in Column C to highlight if they are not within a range of +/- 1 of their counterpart in column B?

Thank you in advance for helping me because, clearly,
Im_Offset :)
 
Top