VBA if end if return value based on empty cell

[melbri]

Sorry, wrong forum. I'll move this to the programming forum.


I am a light user of VBA code, primarily use it to format data pulled from sharepoint. I have found some code= used for multiple if statements,

Sub IFs()
Set MyPlage = Range("S3:S121")
For Each Cell In MyPlage

If Cell.Value = 0 Then
Cell.Interior.ColorIndex = 19
End If
If Cell.Value > 0 Then
Cell.Interior.ColorIndex = 10
End If
If Cell.Value < 0 Then
Cell.Interior.ColorIndex = 7
End If
Next
End Sub

I need at add a condition where a blank cell is recognized. I appreciate any help.

Thanks

[NBVC]

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.