Excel problem with vba code not working

[Alpacino]

Hi I have this code

Sub Cond1()

Dim cell As Range

For Each cell in Range("E5:AC16")

If cell.value > 2 And cell.value < -2 Then
cell.Interior.Color = vbRed
End If
Next cell

End Sub

But nothing happens does anyone know any reasons why????
Am I missing something

 

[VoG]

Both conditions cannot be true. Try

If cell.Value > 2 Or cell.Value < -2 Then

 

[CharlesChuckieCharles]

If cell.value > 2 And cell.value < -2 Then

you are asking if a cell is BOTH > 2 and <-2

If cell.value > 2 OR cell.value < -2 Then

 

[Alpacino]

Of course thanks guys

Just couldn't see it.

Cool.