Hi, here is my code, the problematic line is this: "if cell.value = "".. if TRUE I want Excel to color the entire row, isn't the way to look for empty cell?
Sub look_for_empty()
Worksheets("...").Activate
With ActiveSheet
Dim rng As Range
Dim cell As Range
Set rng = .UsedRange
For Each cell In rng
If cell.Value = "" Then
cell.EntireRow.Font.ColorIndex = 4
End If
Next cell
End With
End Sub