PDA

View Full Version : Solved: Change background colour if cell is blank



khalid79m
04-30-2008, 07:34 AM
:banghead: How do i get the following

with range a3 to aa & lastrow

if any cells are blank give them a green background

??

Bob Phillips
04-30-2008, 08:17 AM
Just use conditional formatting.

Simon Lloyd
04-30-2008, 08:52 AM
If you really want a VBA solution:
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

khalid79m
04-30-2008, 02:45 PM
Thanks works a treat