VB in Excel

[Guest_imported]

hi,

I want to perform the following task, by using macros in Excel:

If a CELL is empty, then the color of the whole ROW should change into RED, otherwise BLACK.

Please assist. Any help is great. Thanks.

 

[swilliams]

In the example below, the cell A3 is hardcoded - change this to look at whatever cells you are interested in, or add a loop, ....

Dim sCol As String
Dim lRow As Long
lRow = 3
sCol = "A"
If Range("" & sCol & lRow & "&quot.FormulaR1C1 = "" Then
Rows("" & lRow & ":" & lRow & "&quot.Select
With Selection.Interior
.ColorIndex = 3
.Pattern = xlSolid
End With
Else
Rows("" & lRow & ":" & lRow & "&quot.Select
With Selection.Interior
.ColorIndex = 1
.Pattern = xlSolid
End With
End If

Simon