Highight cell with non numeric data
Sorry This should have read
If Not(IsNumeric((Cells(Row, 11).Value))) Then
Cells(Row, 11).Interior.ColorIndex = 4
End If
as you are testing for non-numeric values.
Paul
"Billy" wrote in message
...
I'm getting this error
compile error : invalid or unqualified reference
If !IsNumeric((Cells(Row, 11).Value)) Then
Cells(Row, 11).Interior.ColorIndex = 4
End If
I just want to validate that the data in the cell is numeric.
|