How to highlight a row and its previous row for every blank cell in a column
I could only highlight the row containing the blank cell, but not the row above this. Help with my code.
Sub ConditionalFormatter()
[F3].Activate
With Range([F3], [F65536].End(xlUp)).EntireRow
.FormatConditions.Delete
.FormatConditions.Add Type:=xlExpression, Formula1:= _
"=$F3="""""
.FormatConditions(1).Interior.ColorIndex = 6
End With
End Sub
Bookmarks