hey, I am trying to fill in blank cells with color, but the way I am doing it, it does not work.
the lines I am using:
If Wks1.Cells(j, 4).Value = "" Then
Wks1.Cells(j, 4).Interior.ColorIndex = 3
End If
Should it work?
Is there another way how to fill in blank cells with color?
Thank you very much!
Bookmarks