I did not write this code. It is meant to highlight every row if cell in Column P is not null.
It is only hightlighting some rows. It highlighted a row with (77.01) but did not highlight one with 50.05.
I need for it to highlighted rows where cells in column P are not null. Thanks in advance. Using Excel 2010 also.
Dim x As Long
For x = 11 To row - 1
If (Range("P" & x).Value > 0.05 Or Range("P" & x).Value < -0.05) And (Range("N" & x).Value <> "None") Then
With Range(x & ":" & x).Interior
.Pattern = xlSolid
.PatternColorIndex = xlAutomatic
.Color = 65535
.TintAndShade = 0
.PatternTintAndShade = 0