Compund formulae in conditional formatting

[tonygg9]

Hi. I need to highlight a cells in a range in column N based on 2 conditions. Firstly if its non numeric. The second is that if it is not equal to a different cell in column M - however only if the cell in row M is not zero. Hence I need a compound formulae (see below). I guess I have got the compound formulae Formula1:="=((M2<>N2) And M2 > 0)") wrong as it gets kicked out by the debugger. Any ideas on how to make it work would be gratefully received. Many thanks Tony

 
 With ThisWorkbook.Worksheets(1).Range("N2:N" & ColRange)
     With .FormatConditions.Add(Type:=xlExpression, Formula1:="=NOT(ISNUMBER(N2))")
                .Interior.Color = RGB(255, 255, 0)
      End With
      With .FormatConditions.Add(Type:=xlExpression, Formula1:="=((M2<>N2) And M2 > 0)")
                .Interior.Color = RGB(255, 255, 0)
      End With
End With

[millz]

Assuming your logic is correct, it should be:

Formula1:="=AND(M2<>N2, M2>0)")

[tonygg9]

Perfect. All sorted. Many thanks.