conditional formatting

[mattbird]

Hi,

I am using Excel 2010. I am trying to get conditional formatting to colour a cell red if there is 2 or more or 2 less between two cells.

ie L leg cell Z6 and R leg cell AB6:

if L=3 and R=4 Both cells Z6 and AB6 stay clear.
if L=2 and R=4 both cells Z6 and AB6 should turn red.
if L=1 and R=5 both cells Z6 and AB6 should turn red etc

or visa versa

L=3 and R=2 both cells stay clear
L=4 and R=1 both cells turn red

Any help would be great, thanks

 

[Scott T]

Select both Z6 and AB6 (Select Z6 press and hold Ctrl and select AB6)
In conditional formatting select new rule
Select Use a formula to determine which cells to format

use this formula

=ABS($Z$6-$AB$6)>=2

Select your formatting
Press OK

 

[mattbird]

Thanks for your help that works great .

 

[Scott T]

You're welcome