For i = 0 To Me.C1Screen1.Rows.Count - 1
For j = 1 To Me.C1Screen1.Columns.Count - 1
If Me.C1Screen1.Rows(i).Cells(j).Value = "" Then
Me.C1Screen1.Rows(i).Cells(j).Style.BackColor = Color.Red
End If
Next
Next
Open in new window
Please confirm if this works as you wish.
Thanks !