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
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.