Solved: Change background colour if cell is blank

[khalid79m]

How do i get the following

with range a3 to aa & lastrow

if any cells are blank give them a green background

??

[Bob Phillips]

Just use conditional formatting.

[Simon Lloyd]

If you really want a VBA solution:
[VBA]Sub Blank_Colour()
Dim Rng As Range
Set Rng = Range("A3:AA" & Range("AA" & Rows.Count).End(xlUp).Row)
With Rng.SpecialCells(xlCellTypeBlanks)
.Interior.ColorIndex = 4
End With
End Sub[/VBA]

[khalid79m]

Thanks works a treat