Public Sub vev()
Dim i As Integer, j As Integer
For i = Range('a65536').End(xlUp).Row To 4 Step -1
For j = 2 To 4
If Cells(i, j) = 'NA' Or _
Cells(i, j) = '-' Or _
Cells(i, j) = '0' Then
Rows(i).Delete
End If
Next j
If Cells(i, 2) = '' Then
Range(Cells(i, 1), Cells(i, 25)).Font.Bold = True
Range(Cells(i, 1), Cells(i, 25)).Interior.ColorIndex = 37
End If
Next i
End Sub