Make every blank cell highlighted red

[UncleBajubjubs]

Hello, I'm looking for a VBA macro that will make every unfilled cell be highlighted red. I think this shouldn't be too complex, but I was having some issues proceeding. Thanks.

 

[Nine Zero]

Try this out..... just change your range to whatever range you want to cover

Sub Macro1()
Dim r As Range
For Each r In Range("A1:B10") 'change this to accommodate your range
    If r.Value = "" Then
        r.Interior.Color = 255
    End If
Next
End Sub

 

[Fluff]

How about

Sub FillRed()
On Error Resume Next
Cells.SpecialCells(xlBlanks).Interior.Color = vbRed
On Error GoTo 0
End Sub

 

[jmacleary]

Why do you want VBA? You could use conditional formatting with a rule like: =ISBLANK(A1) and apply it to a1:z999 (or whatever your full sheet is).

 

[Nine Zero]

Why do you want VBA? You could use conditional formatting with a rule like: =ISBLANK(A1) and apply it to a1:z999 (or whatever your full sheet is).

I was going to make that suggestion but OP requested VBA so went with VBA ... CF would be less of a hassle

 

[UncleBajubjubs]

Thanks, I was able to get it to work. I asked for VBA thinking it'd be easiest, CF didn't occur to me when i was working on it.

 

[Fluff]

Glad we could help & thanks for the feedback